Wednesday, 31 July 2019
Monday, 13 May 2019
Delete functionality in sitefinity telerik:RadGrid
<telerik:RadGrid>
<MasterTableView DataKeyNames="ID,CategoryName,ParentCategoryID">
<Columns>
<telerik:GridTemplateColumn UniqueName="edit">
<ItemTemplate>
<asp:LinkButton ID="delete_LinkButton" runat="server" Text="delete" CommandName="delete"
CommandArgument='<%# Eval("ID")+";" + Eval("CategoryName") %>' OnCommand="delete_LinkButton_Click"></asp:LinkButton>
</ItemTemplate>
</telerik:GridTemplateColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>
protected void delete_LinkButton_Click(object sender, CommandEventArgs e)
{
try
{
if (e.CommandName == "delete")
{
if (e.CommandArgument.ToString().Contains(";"))
{
string info = e.CommandArgument.ToString();
string[] arg = new string[2];
char[] splitter = { ';' };
arg = info.Split(splitter);
int Cat_Id = Convert.ToInt16(arg[0]);
string Cat_Name = arg[1].ToString();
operation = "D";
int exists = CategoryManager.DeleteCategory(operation, Cat_Id, Cat_Name, null);
//int exists = 1;
if (exists == 1)
{
strDelMsg = "Deleted successfully!";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "SavedSuccess", "alert('" + strDelMsg + "');", true);
BindSchemeCategories();
}
else
{
strDelMsg = "This record cannot be deleted as it is mapped!";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "SavedSuccess", "alert('" + strDelMsg + "');", true);
}
}
else
{
strDelMsg = "This record cannot be deleted as it is mapped!";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "SavedSuccess", "alert('" + strDelMsg + "');", true);
}
}
}
catch (Exception ex)
{
}
}
<MasterTableView DataKeyNames="ID,CategoryName,ParentCategoryID">
<Columns>
<telerik:GridTemplateColumn UniqueName="edit">
<ItemTemplate>
<asp:LinkButton ID="delete_LinkButton" runat="server" Text="delete" CommandName="delete"
CommandArgument='<%# Eval("ID")+";" + Eval("CategoryName") %>' OnCommand="delete_LinkButton_Click"></asp:LinkButton>
</ItemTemplate>
</telerik:GridTemplateColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>
protected void delete_LinkButton_Click(object sender, CommandEventArgs e)
{
try
{
if (e.CommandName == "delete")
{
if (e.CommandArgument.ToString().Contains(";"))
{
string info = e.CommandArgument.ToString();
string[] arg = new string[2];
char[] splitter = { ';' };
arg = info.Split(splitter);
int Cat_Id = Convert.ToInt16(arg[0]);
string Cat_Name = arg[1].ToString();
operation = "D";
int exists = CategoryManager.DeleteCategory(operation, Cat_Id, Cat_Name, null);
//int exists = 1;
if (exists == 1)
{
strDelMsg = "Deleted successfully!";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "SavedSuccess", "alert('" + strDelMsg + "');", true);
BindSchemeCategories();
}
else
{
strDelMsg = "This record cannot be deleted as it is mapped!";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "SavedSuccess", "alert('" + strDelMsg + "');", true);
}
}
else
{
strDelMsg = "This record cannot be deleted as it is mapped!";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "SavedSuccess", "alert('" + strDelMsg + "');", true);
}
}
}
catch (Exception ex)
{
}
}
Tuesday, 2 April 2019
user control use in sitefinity and button submit time dropdown is reset with empty
Refrence: https://docs.telerik.com/devtools/aspnet-ajax/controls/ajaxmanager/how-to/load-user-controls
protected void Page_Load(object sender, EventArgs e)
{
//-----pramod
if (this.CurrentControl != string.Empty)
{
LoadMyUserControl(CurrentControl, this.Page);
}
}
protected void Page_Init(object sender, EventArgs e)
{
FunBindCategory();
}
private string CurrentControl
{
get
{
return this.ViewState["CurrentControl"] == null ? string.Empty : (string)this.ViewState["CurrentControl"];
}
set
{
this.ViewState["CurrentControl"] = value;
}
}
private void LoadMyUserControl(string controlName, Control parent)
{
parent.Controls.Clear();
UserControl MyControl = (UserControl)LoadControl(controlName);
string userControlID = controlName.Split('.')[0];
MyControl.ID = userControlID.Replace("/", "").Replace("~", "");
parent.Controls.Add(MyControl);
this.CurrentControl = controlName;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
this.LoadMyUserControl("~/UserControls/BackendModule/SchemeCategory Master/ucSchemeCategory.ascx", this.Page);
string test= drpcategory.SelectedValue;
}
protected void Page_Load(object sender, EventArgs e)
{
//-----pramod
if (this.CurrentControl != string.Empty)
{
LoadMyUserControl(CurrentControl, this.Page);
}
}
protected void Page_Init(object sender, EventArgs e)
{
FunBindCategory();
}
private string CurrentControl
{
get
{
return this.ViewState["CurrentControl"] == null ? string.Empty : (string)this.ViewState["CurrentControl"];
}
set
{
this.ViewState["CurrentControl"] = value;
}
}
private void LoadMyUserControl(string controlName, Control parent)
{
parent.Controls.Clear();
UserControl MyControl = (UserControl)LoadControl(controlName);
string userControlID = controlName.Split('.')[0];
MyControl.ID = userControlID.Replace("/", "").Replace("~", "");
parent.Controls.Add(MyControl);
this.CurrentControl = controlName;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
this.LoadMyUserControl("~/UserControls/BackendModule/SchemeCategory Master/ucSchemeCategory.ascx", this.Page);
string test= drpcategory.SelectedValue;
}
Monday, 25 March 2019
Thursday, 28 February 2019
Custom Field add in Umbraco CMS
This is folder structure
\App_Plugins\ChannelSelection
channelselection.controller.js
channelselection.html
package.manifest
file contain
------------channelselection.controller.js--------------------
angular.module("umbraco")
.controller("My.ChannelSelectionController",
function ($scope) {
$.ajax({
url: "/umbraco/api/Portfolio/GetDropdownList",
dataType: "json",
type: "GET",
error: function () {
//alert(" An error occurred.");
},
success: function (data) {
console.log(JSON.stringify(data));
$('#fillvalues').find("option").remove();
var option = $("<option/>");
// option.attr("value", "").text("Select Channel");
$("#fillvalues").append(option);
$.each(data, function (i, product) {
$.each(product.Channel, function (j, productj) {
option = $("<option/>");
option.attr("value", productj.Id).text(productj.Name);
$("#fillvalues").append(option);
// contentc += ' <li><a href="' + productj.link + '"><img src="' + productj.Image + '" alt="' + productj.Name + '" /></a></li>';
});
});
$('#fillvalues').val($scope.model.value);
}
});
//alert('Control loaded');
});
--------------------channelselection.html-------------
<div ng-controller="My.ChannelSelectionController">
<select id="fillvalues" ng-model="model.value"></select>
</div>
--------------------package.manifest---------------
{
//you can define multiple editors
propertyEditors: [
{
/*this must be a unique alias*/
alias: "My.ChannelSelection",
/*the name*/
name: "Channel Selection",
/*the html file we will load for the editor*/
editor: {
view: "~/App_Plugins/ChannelSelection/channelselection.html"
}
}
]
,
//array of files we want to inject into the application on app_start
javascript: [
'~/App_Plugins/ChannelSelection/channelselection.controller.js'
]
}
\App_Plugins\ChannelSelection
channelselection.controller.js
channelselection.html
package.manifest
file contain
------------channelselection.controller.js--------------------
angular.module("umbraco")
.controller("My.ChannelSelectionController",
function ($scope) {
$.ajax({
url: "/umbraco/api/Portfolio/GetDropdownList",
dataType: "json",
type: "GET",
error: function () {
//alert(" An error occurred.");
},
success: function (data) {
console.log(JSON.stringify(data));
$('#fillvalues').find("option").remove();
var option = $("<option/>");
// option.attr("value", "").text("Select Channel");
$("#fillvalues").append(option);
$.each(data, function (i, product) {
$.each(product.Channel, function (j, productj) {
option = $("<option/>");
option.attr("value", productj.Id).text(productj.Name);
$("#fillvalues").append(option);
// contentc += ' <li><a href="' + productj.link + '"><img src="' + productj.Image + '" alt="' + productj.Name + '" /></a></li>';
});
});
$('#fillvalues').val($scope.model.value);
}
});
//alert('Control loaded');
});
--------------------channelselection.html-------------
<div ng-controller="My.ChannelSelectionController">
<select id="fillvalues" ng-model="model.value"></select>
</div>
--------------------package.manifest---------------
{
//you can define multiple editors
propertyEditors: [
{
/*this must be a unique alias*/
alias: "My.ChannelSelection",
/*the name*/
name: "Channel Selection",
/*the html file we will load for the editor*/
editor: {
view: "~/App_Plugins/ChannelSelection/channelselection.html"
}
}
]
,
//array of files we want to inject into the application on app_start
javascript: [
'~/App_Plugins/ChannelSelection/channelselection.controller.js'
]
}
Wednesday, 27 February 2019
Json string read in 2.0 frame work and 4.5 frame work c sharp asp.net
Sample json data
{ "d" : { "results" : [ { "ReqId" : "761"]}}}
----------4.5 version---------
JToken token = JToken.Parse(json2);
JArray vacancies = (JArray)token.SelectToken("d.results");
----------2.0 version---------
JObject o = JObject.Parse(json2);
string name = (string)o["d"].ToString();
JObject p = JObject.Parse(name);
JArray vacancies = (JArray)p.SelectToken("results");//d.results
foreach (JToken m in vacancies)
{
Response.Write(m["ReqId"].ToString().Replace("<", "").Replace(">", "").Replace("\"", ""));
}
{ "d" : { "results" : [ { "ReqId" : "761"]}}}
----------4.5 version---------
JToken token = JToken.Parse(json2);
JArray vacancies = (JArray)token.SelectToken("d.results");
----------2.0 version---------
JObject o = JObject.Parse(json2);
string name = (string)o["d"].ToString();
JObject p = JObject.Parse(name);
JArray vacancies = (JArray)p.SelectToken("results");//d.results
foreach (JToken m in vacancies)
{
Response.Write(m["ReqId"].ToString().Replace("<", "").Replace(">", "").Replace("\"", ""));
}
Thursday, 14 February 2019
Convert Json String To DataTable C sharpasp .net
============================================
DataTable [] dt;
string JsonString = string.Empty;
ConvertJsonStringToDataTable jDt = new ConvertJsonStringToDataTable();
JsonString = ui_lbl_JsonString.Text;
dt = jDt.JsonStringToDataTable(JsonString);
=================Logic======================
using System;
using System.Collections.Generic;
using System.Data;
using System.Text.RegularExpressions;
public class ConvertJsonStringToDataTable
{
public DataTable[] JsonStringToDataTable(string jsonString)
{
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
string[] jsonStringArray = Regex.Split(jsonString.Replace("[", "").Replace("]", ""), "},{");
List<string> ColumnsName = new List<string>();
foreach (string jSA in jsonStringArray)
{
string[] jsonStringData = Regex.Split(jSA.Replace("{", "").Replace("}", ""), ",");
foreach (string ColumnsNameData in jsonStringData)
{
try
{
int idx = ColumnsNameData.IndexOf(":");
string ColumnsNameString = ColumnsNameData.Substring(0, idx - 1).Replace("\"", "");
if (!ColumnsName.Contains(ColumnsNameString))
{
if (!ColumnsName.Contains("\\"))
{
ColumnsName.Add(ColumnsNameString);
}
}
}
catch (Exception ex)
{
throw new Exception(string.Format("Error Parsing Column Name : {0}", ColumnsNameData));
}
}
break;
}
foreach (string AddColumnName in ColumnsName)
{
if (AddColumnName.Contains("\\"))
{
dt1.Columns.Add(AddColumnName.Replace("\\",""));
}
else
{
dt.Columns.Add(AddColumnName);
}
}
foreach (string jSA in jsonStringArray)
{
string[] RowData = Regex.Split(jSA.Replace("{", "").Replace("}", ""), ",");
DataRow nr = dt.NewRow();
foreach (string rowData in RowData)
{
try
{
int idx = rowData.IndexOf(":");
string RowColumns = rowData.Substring(0, idx - 1).Replace("\"", "");
string RowDataString = rowData.Substring(idx + 1).Replace("\"", "");
if (!RowDataString.Contains("\\"))
{
nr[RowColumns] = RowDataString;
}
}
catch (Exception ex)
{
continue;
}
}
dt.Rows.Add(nr);
}
foreach (string jSA in jsonStringArray)
{
string[] RowData = Regex.Split(jSA.Replace("{", "").Replace("}", ""), ",");
DataRow nr = dt1.NewRow();
foreach (string rowData in RowData)
{
try
{
int idx = rowData.IndexOf(":");
string RowColumns = rowData.Substring(0, idx - 1).Replace("\"", "");
string RowDataString = rowData.Substring(idx + 1).Replace("\"", "");
if (RowDataString.Contains("\\"))
{
nr[RowColumns.Replace("\\", "")] = RowDataString.Replace("\\", "");
}
}
catch (Exception ex)
{
continue;
}
}
dt1.Rows.Add(nr);
}
return new DataTable[] { dt, dt1 };
}
}
DataTable [] dt;
string JsonString = string.Empty;
ConvertJsonStringToDataTable jDt = new ConvertJsonStringToDataTable();
JsonString = ui_lbl_JsonString.Text;
dt = jDt.JsonStringToDataTable(JsonString);
=================Logic======================
using System;
using System.Collections.Generic;
using System.Data;
using System.Text.RegularExpressions;
public class ConvertJsonStringToDataTable
{
public DataTable[] JsonStringToDataTable(string jsonString)
{
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
string[] jsonStringArray = Regex.Split(jsonString.Replace("[", "").Replace("]", ""), "},{");
List<string> ColumnsName = new List<string>();
foreach (string jSA in jsonStringArray)
{
string[] jsonStringData = Regex.Split(jSA.Replace("{", "").Replace("}", ""), ",");
foreach (string ColumnsNameData in jsonStringData)
{
try
{
int idx = ColumnsNameData.IndexOf(":");
string ColumnsNameString = ColumnsNameData.Substring(0, idx - 1).Replace("\"", "");
if (!ColumnsName.Contains(ColumnsNameString))
{
if (!ColumnsName.Contains("\\"))
{
ColumnsName.Add(ColumnsNameString);
}
}
}
catch (Exception ex)
{
throw new Exception(string.Format("Error Parsing Column Name : {0}", ColumnsNameData));
}
}
break;
}
foreach (string AddColumnName in ColumnsName)
{
if (AddColumnName.Contains("\\"))
{
dt1.Columns.Add(AddColumnName.Replace("\\",""));
}
else
{
dt.Columns.Add(AddColumnName);
}
}
foreach (string jSA in jsonStringArray)
{
string[] RowData = Regex.Split(jSA.Replace("{", "").Replace("}", ""), ",");
DataRow nr = dt.NewRow();
foreach (string rowData in RowData)
{
try
{
int idx = rowData.IndexOf(":");
string RowColumns = rowData.Substring(0, idx - 1).Replace("\"", "");
string RowDataString = rowData.Substring(idx + 1).Replace("\"", "");
if (!RowDataString.Contains("\\"))
{
nr[RowColumns] = RowDataString;
}
}
catch (Exception ex)
{
continue;
}
}
dt.Rows.Add(nr);
}
foreach (string jSA in jsonStringArray)
{
string[] RowData = Regex.Split(jSA.Replace("{", "").Replace("}", ""), ",");
DataRow nr = dt1.NewRow();
foreach (string rowData in RowData)
{
try
{
int idx = rowData.IndexOf(":");
string RowColumns = rowData.Substring(0, idx - 1).Replace("\"", "");
string RowDataString = rowData.Substring(idx + 1).Replace("\"", "");
if (RowDataString.Contains("\\"))
{
nr[RowColumns.Replace("\\", "")] = RowDataString.Replace("\\", "");
}
}
catch (Exception ex)
{
continue;
}
}
dt1.Rows.Add(nr);
}
return new DataTable[] { dt, dt1 };
}
}
Subscribe to:
Posts (Atom)
