Code .CS File Generator

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>

/*
COMPANY NAME :
PROJECT NAME :
CREATE BY :
CREATE DATE : <%= DateTime.Now %>
PURPOSE : FOR <%= dt.TableName%>
MODIFY BY :
MODIFY DATE :
MODIFY PURPOSE :
REMARKS :
*/
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
bind_grid();
SetPanel(true);
}
}

#region "Private Function"

//Set Panel

private SetPanel(bool flg)
{
pnlGrid.Visible = flg;
pnlTrans.Visible = !flg;
}

//Clear Text Function

private void ClearText()
{
<%
foreach (DataColumn col in dt.Columns)
{
%> txt<%=col.ColumnName%>.Text =String.Empty ;
<%
}
%>
}

//Enabled-Disabled Control Function

private void setText(Boolean flg)
{
<%
foreach (DataColumn col in dt.Columns)
{
%> txt<%=col.ColumnName%>.Enabled =flg;
<%
}
%>
}
//Readonly control
private void setReadonly(Boolean flg)
{
<%
foreach (DataColumn col in dt.Columns)
{
%> txt<%=col.ColumnName%>.Readonly =flg;
<%
}

%>
}



//Load Form Data in to CDO

private void Load_Data(ref <%=TableName%> <%=dt.TableName %>_CDO)
{
<%
foreach (DataColumn col in dt.Columns)
{
if ("String" != col.DataType.Name.ToString())
{ %>
<%=dt.TableName %>_CDO.<%=col.ColumnName%> = <%=col.DataType.Name %>.Parse( txt<%=col.ColumnName%>.Text);
<% }
else
{ %>
<%=dt.TableName %>_CDO.<%=col.ColumnName%> = txt<%=col.ColumnName%>.Text;
<% }%>
<%
}
%>
}
// set data rows value to controls
private void setValues(DataSet ds)
{
<%
foreach (DataColumn col in dt.Columns)
{
%>txt<%=col.ColumnName%>.Text = ds.Tables[0].Rows[0]["<%=col.ColumnName%>"].ToString();
<%
}
%>
}

// Common Switch case Function For Save Data
// common function for Save, Update, Delete Records


private Boolean Common_Switch_Case(string strCommandName)
{
Boolean Blnflg=false;
try
{
<%=TableName%> <%=dt.TableName %>_CDO =new <%=TableName%>();
cls<%=dt.TableName %>_DA <%=dt.TableName %>_DA = new cls<%=dt.TableName %>_DA();

if (strCommandName != "Delete") Load_Data(ref <%=dt.TableName %>_CDO);

if (strCommandName != "Save") <%=dt.TableName %>_CDO.<%=dt.TableName %>Id = Int64.Parse(ViewState["<%=dt.TableName %>Id"].ToString());

if (strCommandName != "Delete")

Blnflg = <%=dt.TableName %>_DA.Save_<%=dt.TableName %>(ref <%=dt.TableName %>_CDO,strCommandName);

else

Blnflg = <%=dt.TableName %>_DA.Delete_<%=dt.TableName %>(ref <%=dt.TableName %>_CDO,strCommandName);

}

catch(Exception ex)

{

Session["ex"] = ex;

throw new Exception(ex.Message,ex);

}

return Blnflg;

}



// Grid Binding Function

private void bind_grid()

{

try

{

<%=TableName%> <%=dt.TableName %>_CDO =new <%=TableName%>();

cls<%=dt.TableName %>_DA <%=dt.TableName %>_DA = new cls<%=dt.TableName %>_DA();

DataSet return_ds=new DataSet();

return_ds = <%=dt.TableName %>_DA.View_<%=dt.TableName %>(<%=dt.TableName %>_CDO);

ViewState["table"] = return_ds;

gvHeader.DataSource= return_ds;

gvHeader.DataBind();

}

catch(Exception ex)

{

Session["ex"] = ex;

throw new Exception(ex.Message,ex);

}

}

// DropDownList Binding Function

private DropDownList BindListBox(DropDownList ddlList, DataSet ds,string TextFields,string ValueFields)

{

ddlList.DataSource=ds;

ddlList.DataTextField=TextFields;

ddlList.DataValueField=ValueFields;

ddlList.DataBind();

if (ddlList.Items.Count>0)

{

ddlList.SelectedIndex=-1;

}

return ddlList;

}

#endregion

#region "Button Events"

// code for Save Button

protected void btnSave_Click(object sender, System.EventArgs e)

{

Boolean Blnflg=false;

if(btnSave.Text=="Save")

Blnflg=Common_Switch_Case("Save");

else if(btnSave.Text=="Update")

Blnflg=Common_Switch_Case("Update");

try

{

if (Blnflg)

{

lblstatus_msg.Text = " Record has been saved succesfully";

lblstatus_msg.ForeColor = System.Drawing.Color.Green;

}

else

{

lblstatus_msg.Text = " Record Already Exist";

lblstatus_msg.ForeColor = System.Drawing.Color.Red;

}

SetPanel(false);

bind_grid();

}

catch(Exception ex)

{

Session["ex"] = ex;

throw new Exception(ex.Message,ex);

}

}

// code for cancel button



protected void btnCancel_Click(object sender, System.EventArgs e)

{

try

{

btnCancel.Text="Cancel";

lblstatus_msg.Text="";

bind_grid();

btnSave.Visible=true;

btnAddNew.Visible = true;

SetPanel(true);

}

catch(Exception ex)

{

Session["ex"] = ex;

throw new Exception(ex.Message,ex);

}

}

// add new button click event

protected void btnAddNew_Click(object sender, System.EventArgs e)

{

try

{

ClearText();

setText(true);

SetPanel(false);

btnSave.Text="Save";

lblstatus_msg.Text="";

}

catch(Exception ex)

{

Session["ex"] = ex;

throw new Exception(ex.Message,ex);

}

}

#endregion



#region "Grid Events"

//GRID VIEW PAGEINDEX CHANGE INDEX

protected void gvHeader_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

gvHeader.PageIndex = e.NewPageIndex;

gvHeader.DataSource = (DataSet)ViewState["table"];

gvHeader.DataBind();

}

// GRID VIEW DELETE ROWS COMMAND

protected void gvHeader_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

try

{

<%

foreach (DataColumn col in dt.PrimaryKey)

{ %>

ViewState["<%=col.ColumnName %>"] = ((Label)gvHeader.Rows[e.RowIndex].FindControl("llbl<%=col.ColumnName %>")).Text.ToString();



ViewState["<%=col.ColumnName %>"] = gvHeader.Rows[e.RowIndex].Cells[2].Text.ToString();

<% }

%>

Boolean flg = Common_Switch_Case("Delete");

if (flg)

{

lblstatus_msg.Text = "Deleting Sucessfully";

bind_grid();

}

else

{

lblstatus_msg.Text = "Deleting Error";

}

}

catch (Exception ex)

{

throw ex;

}

}

//GRID VIEW SELECTED INDEX CHANGE EVENTS

protected void gvHeader_SelectedIndexChanged(object sender, EventArgs e)

{

try

{

if (gvHeader.SelectedIndex != -1)

{

<%

foreach (DataColumn col in dt.PrimaryKey)

{ %>

ViewState["<%=col.ColumnName %>"] = ((Label)gvHeader.SelectedRow.FindControl("llbl<%=col.ColumnName %>")).Text.ToString();

ViewState["<%=col.ColumnName %>"] = gvHeader.SelectedRow.Cells[2].Text.ToString();

<% }



%>



<%

int i;

i = 3;

foreach (DataColumn col in dt.Columns)

{

%>txt<%=col.ColumnName%>.Text = gvHeader.SelectedRow.Cells[<%=i%>].Text.ToString();

txt<%=col.ColumnName%>.Text = ((Label)gvHeader.SelectedRow.FindControl("llbl<%=col.ColumnName %>")).Text.ToString();

<%

i++;

}

%>

SetPanel(false);

btnSave.Text = "Update";



}

}

catch (Exception ex)

{

throw ex;

}

}

#endregion