28.12.08

Asp.net and Telerik

Asp.net and Telerik --My Points;

1.)How to make radgrid column visible false.

ViewState["intParentID"] = Convert.ToInt32(Request.QueryString["id"]);

if (ViewState["intParentID"].ToString () != "0")
{
RadgridDisplayCategories.MasterTableView.Columns[1].Visible= false;

}

**********************
2.) Radgrid edit command categoryid value pick up:
int Category_id = Convert.ToInt32(RadgridDisplayCategories.MasterTableView.DataKeyValues[e.Item.ItemIndex]["CategoryID"]);
Response.Redirect("EditCategories.aspx?cid=" + Category_id);

**********************

3.)Javascript alert on page:and delete command of telerik radgrid

int Category_id = Convert.ToInt32(RadgridDisplayCategories.MasterTableView.DataKeyValues[e.Item.ItemIndex]["CategoryID"]);
DataSet objDsCheck = objBll.BLL_DisplayCategories(Category_id);
if (objDsCheck.Tables[0].Rows.Count > 0)
{



}
string strIconpath = "~/CategoriesImages/Icon/" + Category_id+".jpg";
string strmediumpath = "~/CategoriesImages/Medium/" + Category_id + ".jpg";
string strlargepath = "~/CategoriesImages/Large/" + Category_id + ".jpg";
System.IO.File.Delete(Server.MapPath(strIconpath));
System.IO.File.Delete(Server.MapPath(strmediumpath));
System.IO.File.Delete(Server.MapPath(strlargepath));

objBll.BLL_DeleteCategory(Category_id);
**********************

4.)Radgrid hyperlink column querystring pass:

UniqueName="column1">


5.) User control and telerik Controls Register on html page and use:
1.)Radgrid:<%@ Register Assembly="RadGrid.Net2" Namespace="Telerik.WebControls" TagPrefix="radG" %>
2.)<%@ Register Src="../UserControls/HeaderBar.ascx" TagName="HeaderBar" TagPrefix="uc1" %>
3.)<%@ Register Src="../UserControls/Footer.ascx" TagName="Footer" TagPrefix="uc2" %>
4.) <%@ Register Assembly="Fluent.MultiLineTextBoxValidator" Namespace="Fluent" TagPrefix="cc1" %>
5.) <%@ Register Assembly="RadComboBox.Net2" Namespace="Telerik.WebControls" TagPrefix="radC" %>
6.) <%@ Register Assembly="RadAjax.Net2" Namespace="Telerik.WebControls" TagPrefix="radA" %>
7.) <%@ Register TagPrefix="radcln" Namespace="Telerik.WebControls" Assembly="RadCalendar.Net2" %>
8.) <%@ Register TagPrefix="telerik" Namespace="Telerik.WebControls" Assembly="RadEditor.Net2" %>
******************************
a.)





b.)
c.) EnableClientSideRestriction="True" MaxLength="400" ShowCharacterCount="false"
ShowJavascriptAlert="False">


d.)
EnableLoadOnDemand="True" HighlightTemplatedItems="True" DropDownWidth="300px"
ItemRequestTimeout="500" SkinsPath="~/RadControls/skins" RadControlsDir="~/RadControls/skins/"
Skin="WindowsXP"
OnSelectedIndexChanged="RadComboBox2_SelectedIndexChanged" AutoPostBack="True">






Size

Colour

Quantity




<%# DataBinder.Eval(Container.DataItem, "attributes_values_name")%>

<%# DataBinder.Eval(Container.DataItem, "Colour_name") %>

<%# DataBinder.Eval(Container.DataItem, "Quantity")%>


private void DisplaySize()
{
RadComboBox2.DataSource = objBll.BLL_DspProductsSize(Convert.ToInt32(ViewState["ProductsID"]));
RadComboBox2.DataTextField = "attributes_values_name";
RadComboBox2.DataValueField = "Quantity";
RadComboBox2.DataBind();
lblquantity.Text = RadComboBox2.SelectedValue.ToString();
}

e.)


f.) runat="server" MaxDate="3000-12-31" MinDate="2008-03-01" SkinsPath="" Skin=""
EnableTyping="False">



g.) Height="350px" Width ="500px" RadControlsDir="~/RadControls/"
SkinsPath="~/RadControls/Editor/" Skin ="WebBlue"
ToolsFile="~/RadControls/Editor/ToolsFile.xml"
ShowSubmitCancelButtons="False" EnableTab="False"
UseClassicDialogs="True" >

************************************
6.)Validators:
1.)Use javascript on fileupload control:


2.) Category Name:

Display="Dynamic" ErrorMessage="Enter Name" SetFocusOnError="True" ValidationGroup="Save">


3.) Description:

runat="server">

EnableClientSideRestriction="True" MaxLength="400" ShowCharacterCount="false"
ShowJavascriptAlert="False">


******************
7.)Use trim when u use textbox:

objBol.Category_code = textcatcod.Text.Trim();


******************
8.)
a.)Retrieve values from dataset:

DataSet objds;
objds = objBll.BLL_EditCategories(Convert.ToInt32(ViewState["intCatID"]));
textcatname.Text = objds.Tables[0].Rows[0]["Category_name"].ToString();
textcatcod.Text = objds.Tables[0].Rows[0]["Category_code"].ToString();

b.)Retrieve values from List:
List objlist = new List();
objlist = objBll.BLL_DspProductsBYID(Convert.ToInt32(ViewState["ProductsID"]));
textName.Text = objlist[0].Products_Name.ToString();
textModel.Text = objlist[0].Model.ToString();
DrpProductType .SelectedValue = objlist[0].Products_Type.ToString ();



9.)when mastertableview and detailtables use simultaneously of radgrid insert and update record:

a.)Insert: protected void RadGrid1_InsertCommand(object source, Telerik.WebControls.GridCommandEventArgs e)
{ GridEditableItem edititem = e.Item as GridEditableItem;
if ("Attributes_values".Equals(e.Item.OwnerTableView.Name))
{ GridDataItem parentItem = e.Item.OwnerTableView.ParentItem as GridDataItem;
Int32 attributes_id =Convert.ToInt32(parentItem.OwnerTableView.DataKeyValues[parentItem.ItemIndex]["attributes_id"]);
TextBox txtname = edititem.FindControl("TextBox2") as TextBox;
objBol.attributes_values_name = txtname.Text.Trim();
objBol.attributes_id = attributes_id;
objBll.Bll_InsUpdAttributesValues(objBol);

}
else
{
TextBox txtname = edititem.FindControl("TextBox1") as TextBox;
objBol.attributes_id = -1;
objBol.attributes_name = txtname.Text.Trim();
int retval= objBll.Bll_InsUpdAttributes(objBol);
if (retval == -1)
{

}
else {
lblmsg.Text = "";
}

}
}


b.)Update: protected void RadGridAttributes_UpdateCommand(object source, GridCommandEventArgs e)
{ GridEditableItem edititem = e.Item as GridEditableItem;
GridDataItem item = e.Item as GridDataItem;
if ("Attributes_values".Equals(e.Item.OwnerTableView.Name))
{
TextBox txtname = edititem.FindControl("TextBox2") as TextBox;
objBol.attributes_values_id = Convert.ToInt32(e.Item .OwnerTableView.DataKeyValues [e.Item.ItemIndex]["attributes_values_id"]);
objBol.attributes_values_name = txtname.Text.Trim();
objBol.attributes_id = -1;
objBll.Bll_InsUpdAttributesValues(objBol);

}
else
{
TextBox txtname = edititem.FindControl("TextBox1") as TextBox;
objBol.attributes_id =Convert .ToInt32 ( RadGridAttributes .MasterTableView .DataKeyValues[e.Item .ItemIndex ] ["attributes_id"]);
objBol.attributes_name = txtname.Text.Trim();
int retval= objBll.Bll_InsUpdAttributes(objBol);
if (retval == -1)
{
lblmsg.Text = "Product Type Exists";
}
else
{
lblmsg.Text = "";
}
}
}

c.)Delete: protected void RadGridAttributes_DeleteCommand(object source, GridCommandEventArgs e)
{
if ("Attributes_values".Equals(e.Item.OwnerTableView.Name))
{
try
{
int attributesid;
attributesid = Convert.ToInt32(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["attributes_values_id"]);
objBll.BLL_DeleteAttributesValues(attributesid);
}
catch(Exception)
{


}

}
else
{
try
{
int attributes_id;
attributes_id = Convert.ToInt32(RadGridAttributes.MasterTableView.DataKeyValues[e.Item.ItemIndex]["attributes_id"]);
objBll.BLL_DeleteAttributes(attributes_id);
}
catch (Exception)
{


}
}
}
**************
10.) Datalist Edit command:

Int32 productsimageId = Convert.ToInt32(DlistProducts.DataKeys[e.Item.ItemIndex]);

11.)Delete files from folders:
datalist delete command:

Int32 productsimageId = Convert.ToInt32(DlistProducts.DataKeys[e.Item.ItemIndex]);
int retval= objBll.BLL_DeleteProductsImages(productsimageId);
if (retval > 0)
{
string strIconpath = "~/ProductsImages/Icon/" + productsimageId + ".jpg";
string strmediumpath = "~/ProductsImages/Medium/" + productsimageId + ".jpg";
string strlargepath = "~/ProductsImages/Large/" + productsimageId + ".jpg";
System.IO.File.Delete(Server.MapPath(strIconpath));
System.IO.File.Delete(Server.MapPath(strmediumpath));
System.IO.File.Delete(Server.MapPath(strlargepath));
}
***************
12.)Master table view only of radgrid:

a.)
Insert:
click on addcolour of top:

GridEditableItem edititem = e.Item as GridEditableItem;
TextBox textColourName = edititem.FindControl("textColourName") as TextBox;
objBol.ColourID = -1;
objBol.Colour_name = textColourName.Text.Trim();
objBol.Image_path = "";
int retval= objBll.BLL_InsUpdColour(objBol);

b.)Update:

GridEditableItem edititem = e.Item as GridEditableItem;
TextBox textColourName = edititem.FindControl("textColourName") as TextBox;
objBol.ColourID =Convert .ToInt32 ( RadgridDisplayColour .MasterTableView .DataKeyValues [e.Item.ItemIndex ]["ColourID"]);
objBol.Colour_name = textColourName.Text.Trim();
objBol.Image_path = "";

c.) Delete:

int colourID;
colourID = Convert.ToInt32(RadgridDisplayColour.MasterTableView.DataKeyValues[e.Item.ItemIndex]["ColourID"]);
objBll.BLL_DeleteColour(colourID);
RadgridDisplayColour.Rebind();

***************
13.) Radgrid Calendar value Insert:

objBol.Promotion_id = -1;
objBol.Promotion_name = (e.Item.FindControl("txtPromotionName") as TextBox).Text.Trim();
objBol.Promotion_code = (e.Item.FindControl("txtPromotionCode") as TextBox).Text.Trim();
objBol.Promotion_discount_value = Convert.ToDecimal((e.Item.FindControl("txtDiscountValue") as TextBox).Text.Trim());
objBol.Promotion_description = (e.Item.FindControl("txtDescription") as TextBox).Text.Trim();
RadDatePicker StrtDate = (RadDatePicker)e.Item.FindControl("txtPstartDate");
if (StrtDate != null)
{
objBol .Promotion_stardate = ((DateTime)StrtDate.SelectedDate);
}
RadDatePicker EndDate = (RadDatePicker)e.Item.FindControl("txtPEndDate");
if (EndDate != null)
{
objBol.Promotion_enddate = ((DateTime)EndDate.SelectedDate);
}
CheckBox chkactive = (CheckBox)e.Item.FindControl("chkPactive");
if (chkactive.Checked == true)
{
objBol.Promotion_active = true;
}
else
{
objBol.Promotion_active = false;
}

******************
14.)RadEditor Values Pick Up:

objBol.EmailID = Convert .ToInt32 (ViewState["EmailID"]);
objBol.Sender = textSender.Text.Trim();
objBol.Subject = textSubject.SelectedValue;
objBol.Header = "";
objBol.Body = RadBody.Html;
objBol.Footer = RadFooter.Html;

No comments: