private void Save() { CultureInfo cult = new CultureInfo("hi-IN"); string ref_no = ""; if (Ddl_advancerefNo.SelectedIndex > 0) { ref_no = Ddl_advancerefNo.SelectedItem.Text; } else { ref_no = ""; } pl.fin_year = ddlFinancial.SelectedValue; pl.EmpType = ddlEmpType.SelectedValue; pl.ECODE = ddl_emp.SelectedValue; pl.EMP_NAME = ddl_emp.SelectedItem.Text; pl.GPS_NPS = ddlGpsMps.SelectedValue; pl.refrence_no = ref_no; pl.freeze_flage = "N"; if (btnSave.Text == "Save") { pl.sptype = 1; pl.CreatedBy = Session["USERID"].ToString(); } else { pl.UpdatedBy = Session["UserID"].ToString(); pl.TableID = Convert.ToInt32(lblRecordID.Text); pl.sptype = 2; } List <PL_levelchild> objlist = new List <PL_levelchild>(); for (int row = 0; row < Grd.Rows.Count; row++) { PL_levelchild pd = new PL_levelchild(); pd.ChildName = Grd.Rows[row].Cells[0].Text; pd.DOB = Convert.ToDateTime(Grd.Rows[row].Cells[1].Text, cult); pd.SchoolName = Grd.Rows[row].Cells[2].Text; pd.Class = Grd.Rows[row].Cells[3].Text; pd.Monthly_TuitionFee = Grd.Rows[row].Cells[4].Text; pd.TuitionFee_Actually_Paid = Convert.ToDecimal(Grd.Rows[row].Cells[5].Text); pd.Amount_Reimbursement_Claimed = Convert.ToDecimal(Grd.Rows[row].Cells[6].Text); objlist.Add(pd); } string xmlDoc = CommonCode.ConvertToXMLFormat <PL_levelchild>(ref objlist); int result = bl.Insert(pl, xmlDoc); if (result > 0) { Reset(); bindgrdData(); Messagebox.Show(pl.MSG); } else { Messagebox.Show(pl.MSG); } }
private void Save() { CultureInfo cult = new CultureInfo("hi-IN"); string ref_no = ""; if (Ddl_advancerefNo.SelectedIndex > 0) { ref_no = Ddl_advancerefNo.SelectedItem.Text; } else { ref_no = ""; } pl.fin_year = ddlFinancial.SelectedValue; pl.EmpType = ddlEmpType.SelectedValue; pl.ECODE = ddl_emp.SelectedValue; pl.EMP_NAME = ddl_emp.SelectedItem.Text; pl.GPS_NPS = ddlGpsMps.SelectedValue; pl.refrence_no = ref_no; pl.freeze_flage = "N"; pl.CorpOffice = lblCorpOffice.Text; pl.PersonalNo = lblPersonalNo.Text; pl.PayAccount = lblPayAccount.Text; pl.BasicPay = Convert.ToDecimal(lblBasicPay.Text); pl.TransferedFrom = txtTransferedFrom.Text.ToString(); pl.RuleTrSr = txtRuleTrSr.Text.ToString(); pl.REFRENCENo = txtReferenceNo.Text.ToString(); pl.Place = txtPlace.Text.ToString(); pl.Date_of_L = txtDate.Text.ToString(); pl.Departure = txtDeparture.Text.ToString(); pl.Arrival = txtArrival.Text.ToString(); pl.DailyAllowanceFor_Adults = Convert.ToDecimal(txtDailyAllAdult.Text.Trim()); pl.NoOf_Adult = Convert.ToDecimal(txtNoAdult.Text.Trim()); pl.Days_Adults = Convert.ToDecimal(txtAdultdays.Text.Trim()); pl.Amount_Adults = Convert.ToDecimal(txtAdultAmount.Text.Trim()); pl.DailyAllowanceFor_Minor = Convert.ToDecimal(txtDailyallownMinors.Text.Trim()); pl.NoOf_Minor = Convert.ToDecimal(txtNoOfMinors.Text.Trim()); pl.Days_Minor = Convert.ToDecimal(txtMinorsDays.Text.Trim()); pl.Amount_Minor = Convert.ToDecimal(txtMinorAmount.Text.Trim()); pl.Luggage = txtluggage.Text.ToString(); pl.Weight = Convert.ToDecimal(txtWeight.Text.Trim()); pl.LuggageConveyance = Convert.ToDecimal(txtLuggageConveyance.Text.Trim()); pl.Cartage_Residence_Booking_Office = txtCartageResBOffice.Text.ToString(); pl.Cartage_Booking_Office_to_Residence = txtCartageBookingOfficetoRes.Text.ToString(); if (btnSave.Text == "Save") { pl.sptype = 1; pl.CreatedBy = Session["USERID"].ToString(); } else { pl.UpdatedBy = Session["UserID"].ToString(); pl.TableID = Convert.ToInt32(lblRecordID.Text); pl.sptype = 2; } List <PL_Details_JourneyChild> objlist = new List <PL_Details_JourneyChild>(); for (int row = 0; row < Grd.Rows.Count; row++) { PL_Details_JourneyChild pd = new PL_Details_JourneyChild(); pd.JourneyFrom = Grd.Rows[row].Cells[0].Text; pd.JourneyTo = Grd.Rows[row].Cells[1].Text; pd.Mode_of_Conveyance = Grd.Rows[row].Cells[2].Text; pd.Class = Grd.Rows[row].Cells[3].Text; pd.Distance = Convert.ToDecimal(Grd.Rows[row].Cells[4].Text); pd.Rate = Convert.ToDecimal(Grd.Rows[row].Cells[5].Text); pd.Amount = Convert.ToDecimal(Grd.Rows[row].Cells[6].Text); objlist.Add(pd); } string xmlDoc = CommonCode.ConvertToXMLFormat <PL_Details_JourneyChild>(ref objlist); List <PL_Details_Family_Members> objlist1 = new List <PL_Details_Family_Members>(); for (int row = 0; row < Grd1.Rows.Count; row++) { PL_Details_Family_Members pd1 = new PL_Details_Family_Members(); pd1.Name = Grd1.Rows[row].Cells[0].Text; pd1.Age = Grd1.Rows[row].Cells[1].Text; pd1.Relation = Grd1.Rows[row].Cells[2].Text; objlist1.Add(pd1); } string xmlDoc1 = CommonCode.ConvertToXMLFormat <PL_Details_Family_Members>(ref objlist1); int result = bl.Insert(pl, xmlDoc, xmlDoc1); if (result > 0) { Reset(); bindgrdData(); Messagebox.Show(pl.MSG); } else { Messagebox.Show(pl.MSG); } }
private void Save() { // string format = "d"; CultureInfo cult = new CultureInfo("hi-IN"); string ref_no = ""; if (Ddl_advancerefNo.SelectedIndex > 0) { ref_no = Ddl_advancerefNo.SelectedItem.Text; } else { ref_no = ""; } pl.fin_year = ddlFinancial.SelectedValue; pl.EmpType = ddlEmpType.SelectedValue; pl.ECODE = ddl_emp.SelectedValue; pl.EMP_NAME = ddl_emp.SelectedItem.Text; pl.GPS_NPS = ddlGpsMps.SelectedValue; pl.refrence_no = ref_no; pl.freeze_flage = "N"; pl.DoB = Convert.ToDateTime(lblDoB.Text); pl.DateTime_Of_Start = Convert.ToDateTime(txtDateTimeStrt.Text); pl.Ranks = lblRank.Text.ToString(); pl.Gpf_Pran_No = Convert.ToDecimal(lblGPFNo.Text.Trim()); pl.BasicPay = Convert.ToDecimal(lblBasicPay.Text.Trim()); pl.HeadqtrOffice = ddlHdtrOffice.SelectedValue.ToString(); pl.OrderForMove_Duty = txtOfMDuty.Text.Trim(); pl.AuthorityRule_TR_SR = txtAuthRole.Text.Trim(); pl.StationFrom_Journey_commenced = txtStationfrmjnycom.Text.Trim(); pl.Levels = lblLevel.Text.Trim(); pl.Cells = lblCell.Text.Trim(); if (btnSave.Text == "Save") { pl.sptype = 1; pl.CreatedBy = Session["USERID"].ToString(); } else { pl.UpdatedBy = Session["UserID"].ToString(); pl.TableID = Convert.ToInt32(lblRecordID.Text); pl.sptype = 2; } List <PL_Tempdutychild> objlist = new List <PL_Tempdutychild>(); for (int row = 0; row < Grd.Rows.Count; row++) { PL_Tempdutychild pd = new PL_Tempdutychild(); pd.NameOfPlace_Arrived_At = Grd.Rows[row].Cells[0].Text; pd.Arvl_Date = Convert.ToDateTime(Grd.Rows[row].Cells[1].Text, cult); pd.Arvl_Hrs = Grd.Rows[row].Cells[2].Text; pd.Distance_by_Road = Grd.Rows[row].Cells[3].Text; pd.ConveyMode = Grd.Rows[row].Cells[4].Text; pd.ConveyClass = Grd.Rows[row].Cells[5].Text; pd.Departure_Date = Convert.ToDateTime(Grd.Rows[row].Cells[6].Text, cult); pd.Departure_Hrs = Grd.Rows[row].Cells[7].Text; pd.NoOfDA = Convert.ToDecimal(Grd.Rows[row].Cells[8].Text); pd.Rate_RMA_DA = Grd.Rows[row].Cells[9].Text; pd.Amount = Convert.ToDecimal(Grd.Rows[row].Cells[10].Text); pd.Remark = Grd.Rows[row].Cells[11].Text; objlist.Add(pd); } string xmlDoc = CommonCode.ConvertToXMLFormat <PL_Tempdutychild>(ref objlist); int result = bl.Insert(pl, xmlDoc); if (result > 0) { Reset(); bindgrdData(); Messagebox.Show(pl.MSG); } else { Messagebox.Show(pl.MSG); } }