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