public void fillEditForm()
{
Clear();
DataTable dt = G_CN.GetCNOnDocNo(0, txtDocIdEdit.Text.Trim(), Convert.ToInt32(strFY)).Tables[0];
if (dt.Rows.Count > 0)
{
DataTable dt1 = new DataTable();
dt1.Columns.Add("GCN_ID");
dt1.Columns.Add("GCN_NO");
dt1.Columns.Add("GCN_Date");
dt1.Columns.Add("SALES_REP");
dt1.Columns.Add("SCHL_ID");
dt1.Columns.Add("SCHL_NAME");
dt1.Columns.Add("SCHL_AREA");
dt1.Columns.Add("SALES_CN_NO");
dt1.Columns.Add("NAR");
for (int i = 0; i < dt.Rows.Count; i++)
{
dt1.Rows.Add(dt.Rows[i]["GCN_ID"].ToString(), dt.Rows[i]["GCN_NO"].ToString(), dt.Rows[i]["GCN_DATE"].ToString(), dt.Rows[i]["SALES_REPRESENTATIVE"].ToString(), dt.Rows[i]["SCHL_ID"].ToString(), dt.Rows[i]["SCHL_NAME"].ToString(), dt.Rows[i]["AREA"].ToString(), dt.Rows[i]["SALESMAN_CN_NO"].ToString(), dt.Rows[i]["Narration"].ToString());
}
Session["getcntempdata"] = dt1;
grdTemp.DataSource = Session["getcntempdata"];
grdTemp.DataBind();
//string date = (Convert.ToDateTime(dt.Rows[0]["GCN_DATE"].ToString())).ToString("dd/MM/yyyy");
//lblDocNo.Text = dt.Rows[0]["GCN_ID"].ToString();
//lblID.Text = dt.Rows[0]["GCN_ID"].ToString();
//txtGCNNo.Text = dt.Rows[0]["GCN_NO"].ToString();
//txtSalesREp.Text = dt.Rows[0]["SALES_REPRESENTATIVE"].ToString();
//lblCustomer.Text = dt.Rows[0]["CustomerName"].ToString();
//lblSchoolID.Text = dt.Rows[0]["SCHL_ID"].ToString();
//txtSchool.Text = dt.Rows[0]["SCHL_NAME"].ToString();
//txtArea.Text = dt.Rows[0]["AREA"].ToString();
//txtSalesManRecNo.Text = dt.Rows[0]["SALESMAN_CN_NO"].ToString();
//txtNarration.Text = dt.Rows[0]["Narration"].ToString();
//txtGCNDate.Text = date;
//CallButonVisible("edit");
//txtGCNNo.Focus();
}
else
{
MessageBox("Info! : \\r\\n GCN. No. " + txtDocIdEdit.Text.Trim() + " Not Found!!!");
//txtDocIdEdit.Text = "";
//txtDocIdEdit.Focus();
ModalPopUpDocNum.Show();
}
}
protected void grdTemp_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int gid = Convert.ToInt32(((Label)grdTemp.Rows[e.RowIndex].FindControl("lblnewid")).Text);
G_CN _obj = new G_CN();
if (gid != 0)
{
_obj.GCN_ID = gid;
_obj.DeleteCN();
}
DataTable dt1 = new DataTable();
dt1 = (DataTable)Session["getcntempdata"];
dt1.Rows[e.RowIndex].Delete();
DataView dv = new DataView(dt1);
dv.RowFilter = "GCN_ID is not null";
grdTemp.DataSource = dv.ToTable();
grdTemp.DataBind();
Session["getcntempdata"] = dv.ToTable();
loder("Successfully Deleted...", "3000");
txtGCNNo.Focus();
}
public void SaveMain()
{
string newDate = "";
try
{
G_CN _objCN = new G_CN();
if (lblEditMode.Text == "edit")
{
_objCN.GCN_ID = Convert.ToInt32(lblGcnId.Text);
_objCN.GCN_NO = txtGCNNo.Text.Trim();
if (txtGCNDate.Text.Trim() == "")
{
newDate = DateTime.Now.ToString("MM/dd/yyyy");
}
else
{
newDate = txtGCNDate.Text.Split('/')[1] + "/" + txtGCNDate.Text.Split('/')[0] + "/" + txtGCNDate.Text.Split('/')[2];
}
_objCN.GCN_DATE = Convert.ToDateTime(newDate);
_objCN.SALES_REPRESENTATIVE = txtSalesREp.Text.Trim();
_objCN.SCHL_NAME = txtSchool.Text.Trim();
_objCN.SCHL_ID = Convert.ToInt32(lblSchoolID.Text.Trim());
_objCN.SALESMAN_CN_NO = txtSalesManRecNo.Text.Trim();
_objCN.AREA = txtArea.Text.Trim();
_objCN.Created_By = UserName;
_objCN.Updated_By = UserName;
_objCN.Narration = txtNarration.Text.Trim();
_objCN.Fy = Convert.ToInt32(strFY);
_objCN.Save();
MessageBox("Record saved successfully");
Clear();
txtGCNNo.Text = "";
Session["getcntempdata"] = null;
grdTemp.DataSource = null;
grdTemp.DataBind();
}
else
{
if (grdTemp.Rows.Count > 0)
{
foreach (GridViewRow row in grdTemp.Rows)
{
_objCN.GCN_ID = Convert.ToInt32(((Label)(row.FindControl("lblnewid"))).Text.Trim());
_objCN.GCN_NO = ((Label)(row.FindControl("lblGCN_NO"))).Text.Trim();
string GCNDate = ((Label)(row.FindControl("lblGCN_Date"))).Text.Trim();
if (GCNDate.ToString() == "")
{
newDate = DateTime.Now.ToString("MM/dd/yyyy");
}
else
{
newDate = GCNDate.Split('/')[1] + "/" + GCNDate.Split('/')[0] + "/" + GCNDate.Split('/')[2];
}
_objCN.GCN_DATE = Convert.ToDateTime(newDate);
_objCN.SALES_REPRESENTATIVE = ((Label)(row.FindControl("lblSALES_REP"))).Text.Trim();
_objCN.SCHL_NAME = ((Label)(row.FindControl("lblSCHL_NAME"))).Text.Trim();
_objCN.SCHL_ID = Convert.ToInt32(((Label)(row.FindControl("lblSCHL_ID"))).Text.Trim());
_objCN.SALESMAN_CN_NO = ((Label)(row.FindControl("lblSALES_CN_NO"))).Text.Trim();
_objCN.AREA = ((Label)(row.FindControl("lblSCHL_AREA"))).Text.Trim();
_objCN.Created_By = UserName;
_objCN.Updated_By = UserName;
_objCN.Narration = ((Label)(row.FindControl("lblNAR"))).Text.Trim();
_objCN.Fy = Convert.ToInt32(strFY);
_objCN.Save();
MessageBox("Record saved successfully");
Clear();
Session["getcntempdata"] = null;
grdTemp.DataSource = null;
grdTemp.DataBind();
}
}
else
{
MessageBox("No Record found!!!");
}
}
if (Convert.ToInt32(lblID.Text) > 0)
{
MessageBox("Record updated successfully");
}
else
{
//MessageBox("Record saved successfully");
//Clear();
}
}
catch (Exception ex)
{
MessageBox("Error : " + ex.Message.ToString());
}
}
