protected void lnkszname_Click(object sender, EventArgs e)
{
LinkButton lnkszid = (LinkButton)sender;
string SZID = lnkszid.CommandArgument.ToString();
GrdDetails.DataSource = Idv.Chetana.BAL.Other.Dashboard.Get_Dasboard_ForOrderValuation(fdate, tdate, Convert.ToInt32(SZID), Convert.ToInt32(strFY)).Tables[2];
GrdDetails.DataBind();
modalPopupForZone.Show();
}
public void BindGvDetail()
{
setActiveUrl();
if (Group == "PVM")
{
GrdDetails.Columns[2].Visible = true;
GrdDetails.Columns[1].HeaderStyle.Width = 20;
GrdDetails.Columns[1].HeaderText = "(%)";
}
else
{
GrdDetails.Columns[2].Visible = false;
}
GrdDetails.DataSource = Masterofmaster.Get_MasterOfMaster_ByGroup(Group);
GrdDetails.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
SetView();
if (!Page.IsPostBack)
{
DataSet ds = new DataSet();
ds = GroupMaster.GetGroupmaster("Group");
GrdDetails.DataSource = GroupMaster.GetGroupmaster("Group");
GrdDetails.DataBind();
DataView dv = new DataView(ds.Tables[0]);
Session["data"] = dv;
//repAlfabets.DataSource = Customer_cs.GetAlphabets();
// repAlfabets.DataBind();
}
else
{
// pnlSuperZone.Visible = true;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
GroupMaster _objGrp = new GroupMaster();
_objGrp.GrpID = Convert.ToInt32(lblGrpID.Text);
_objGrp.GrpCode = txtGrpCode.Text.Trim();
_objGrp.GrpName = txtGrpName.Text.Trim();
_objGrp.IsActive = chkActive.Checked;
try
{
_objGrp.Save();
MessageBox("Record saved successfully");
GrdDetails.DataSource = GroupMaster.GetGroupmaster("Group");;
GrdDetails.DataBind();
if (btnSave.Text == "Update")
{
pnlgroupdetails.Visible = true;
pnlgroup.Visible = false;
btnSave.Visible = false;
btnSave.Text = "Save";
txtGrpCode.Enabled = true;
filter.Visible = true;
}
else
{
pnlgroupdetails.Visible = false;
pnlgroup.Visible = true;
txtGrpCode.Text = "";
txtGrpName.Text = "";
txtGrpCode.Focus();
}
}
catch
{
}
}
private void Export()
{
DataTable dt = Data();
string FileName = "EMSDB_DetailReport.xls";
Response.Clear();
Response.Buffer = true;
// Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.xls");
Response.AddHeader("content-disposition", "attachment;filename=" + FileName + ".xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
using (StringWriter sw = new StringWriter())
{
HtmlTextWriter hw = new HtmlTextWriter(sw);
//To Export all pages
GrdDetails.AllowPaging = false;
if (dt.Rows.Count < 1)
{
ScriptManager.RegisterStartupScript(this, GetType(), "YourUniqueScriptKey", "alert('No records found');", true);
return;
}
else
{
GrdDetails.DataSource = dt;
GrdDetails.DataBind();
}
GrdDetails.HeaderRow.BackColor = Color.White;
foreach (TableCell cell in GrdDetails.HeaderRow.Cells)
{
cell.BackColor = GrdDetails.HeaderStyle.BackColor;
}
foreach (GridViewRow row in GrdDetails.Rows)
{
row.BackColor = Color.White;
foreach (TableCell cell in row.Cells)
{
if (row.RowIndex % 2 == 0)
{
cell.BackColor = GrdDetails.AlternatingRowStyle.BackColor;
}
else
{
cell.BackColor = GrdDetails.RowStyle.BackColor;
}
cell.CssClass = "textmode";
}
}
GrdDetails.RenderControl(hw);
//style to format numbers to string
// string style = @"<style> .textmode { } </style>";
string style = @"<style> .textmode { mso-number-format:\@; } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
public void BindGvDetail()
{
setActiveUrl();
GrdDetails.DataSource = Masterofmaster.Get_MasterOfMaster_ByGroup(Group);
GrdDetails.DataBind();
}
protected void GrdDetails_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GrdDetails.PageIndex = e.NewPageIndex;
GrdDetails.DataSource = (DataTable)Session["schememapping"];
GrdDetails.DataBind();
}
public void BindDetail()
{
Session["schememapping"] = Scheme.Get_Scheme_Customer_Mapping("", "", Convert.ToInt32(strFY)).Tables[0];
GrdDetails.DataSource = (DataTable)Session["schememapping"];
GrdDetails.DataBind();
}
public void BindDetail()
{
GrdDetails.DataSource = Scheme.Get_Scheme_Customer_Mapping("", "", Convert.ToInt32(strFY));
GrdDetails.DataBind();
}
