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()); } }