//public IList FillPartyDetail(Int64 PartyIdno)
//{
// using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
// {
// var lst = (from Acnt in db.AcntMasts
// join ADetl in db.AcntDetls on Acnt.Acnt_Idno equals ADetl.Acnt_Idno into AD
// from ACD in AD.DefaultIfEmpty()
// join CM in db.tblCityMasters on ACD.CityId equals CM.City_Idno into CM
// from CMD in CM.DefaultIfEmpty()
// join StM in db.tblStateMasters on ACD.StateId equals StM.State_Idno into StM
// from SMD in StM.DefaultIfEmpty()
// where Acnt.Acnt_Idno == PartyIdno
// select
// new
// {
// Acnt.Acnt_Name,
// ACD.Temp_Adrs,
// ACD.Temp_Adrs2,
// CityName = CMD.Name,
// ACD.Prty_Pin,
// StateName = SMD.Name
// }
// ).ToList();
// return lst;
// }
//}
public tblChlnBookHead SelectChallanType(Int64 ChlnID)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblChlnBookHead obj = (from t in db.tblChlnBookHeads where t.Chln_Idno == ChlnID select t).FirstOrDefault();
return(obj);
}
}
private void PostIntoAccount(long chlnidno, string GrType)
{
ChlnBookingDAL objChln = new ChlnBookingDAL();
tblChlnBookHead chlnBookhead = objChln.selectHead(chlnidno, GrType);
if (this.RecPostIntoAccounts(Convert.ToDouble(chlnBookhead.Adv_Amnt), Convert.ToInt32(chlnidno), "CBU", 0, 0, 0, 0, 0, Convert.ToInt32(chlnBookhead.Year_Idno), Convert.ToInt32(chlnBookhead.Truck_Idno), Convert.ToString(chlnBookhead.Inst_Dt), (string.IsNullOrEmpty(chlnBookhead.Inst_No.ToString()) ? "0" : Convert.ToString(chlnBookhead.Inst_No)), (string.IsNullOrEmpty(chlnBookhead.Driver_Idno.ToString()) ? 0 : Convert.ToInt32(chlnBookhead.Driver_Idno)), Convert.ToDateTime(chlnBookhead.Chln_Date).ToString("dd-MM-yyyy"), Convert.ToInt32(chlnBookhead.Chln_No), (string.IsNullOrEmpty(chlnBookhead.RcptType_Idno.ToString()) ? 0 : Convert.ToInt32(chlnBookhead.RcptType_Idno)), (string.IsNullOrEmpty(chlnBookhead.Bank_Idno.ToString()) ? 0 : Convert.ToInt32(chlnBookhead.Bank_Idno)), Convert.ToDouble(chlnBookhead.Gross_Amnt), Convert.ToDouble(chlnBookhead.Commsn_Amnt), Convert.ToDouble(chlnBookhead.TDSTax_Amnt), (string.IsNullOrEmpty(chlnBookhead.Diesel_Amnt.ToString()) ? 0.00 : Convert.ToDouble(chlnBookhead.Diesel_Amnt))) == true)
{
// tScope.Complete(); tScope.Dispose();
objChln.UpdateIsPosting(chlnidno);
}
}
public int Delete(Int64 HeadId)
{
int value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
clsAccountPosting objclsAccountPosting = new clsAccountPosting();
tblChlnBookHead CH = db.tblChlnBookHeads.Where(h => h.Chln_Idno == HeadId).FirstOrDefault();
List <tblChlnBookDetl> CD = db.tblChlnBookDetls.Where(d => d.ChlnBookHead_Idno == HeadId).ToList();
if (CH != null)
{
foreach (var d in CD)
{
TblGrHead objTblGrHead = (from obj in db.TblGrHeads where obj.GR_Idno == d.GR_Idno select obj).FirstOrDefault();
objTblGrHead.Chln_Idno = 0;
db.SaveChanges();
}
foreach (var d in CD)
{
db.tblChlnBookDetls.DeleteObject(d);
db.SaveChanges();
}
db.tblChlnBookHeads.DeleteObject(CH);
TblGrHead GrHEad = db.TblGrHeads.Where(rd => rd.Chln_Idno == Convert.ToInt32(HeadId)).FirstOrDefault();
List <TblGrDetl> GrDetl = db.TblGrDetls.Where(rd => rd.GrHead_Idno == GrHEad.GR_Idno).ToList();
foreach (TblGrDetl rgd in GrDetl)
{
db.TblGrDetls.DeleteObject(rgd);
db.SaveChanges();
}
db.TblGrHeads.DeleteObject(GrHEad);
db.SaveChanges();
Int64 intValue = objclsAccountPosting.DeleteAccountPosting(HeadId, "CB");
db.SaveChanges();
if (intValue > 0)
{
value = 1;
}
}
}
return(value);
}
public Int64 Insert(tblChlnBookHead obj, DataTable Dttemp, string GrHeadsIdno)
{
Int64 chlnBookId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblChlnBookHead CHead = new tblChlnBookHead();
tblChlnBookHead RH = db.tblChlnBookHeads.Where(rh => (rh.Chln_No == obj.Chln_No) && (rh.Year_Idno == obj.Year_Idno) && (rh.BaseCity_Idno == obj.BaseCity_Idno) && rh.Chln_type == 2).FirstOrDefault();
if (RH != null)
{
chlnBookId = -1;
}
else
{
db.tblChlnBookHeads.AddObject(obj);
db.SaveChanges();
chlnBookId = obj.Chln_Idno;
string[] GrIdnos = GrHeadsIdno.Split(new string[] { "," }, StringSplitOptions.None);
if (Dttemp.Rows.Count > 0)
{
for (int i = 0; i < Dttemp.Rows.Count; i++)
{
tblChlnBookDetl objtblChlnBookDetl = new tblChlnBookDetl();
objtblChlnBookDetl.GR_Idno = Convert.ToInt32(GrIdnos[i + 1]);
objtblChlnBookDetl.DelvryPlce_Idno = Convert.ToInt32(Dttemp.Rows[i]["ToCityIdno"]);
objtblChlnBookDetl.ChlnBookHead_Idno = chlnBookId;
db.tblChlnBookDetls.AddObject(objtblChlnBookDetl);
db.SaveChanges();
}
}
if (Dttemp.Rows.Count > 0)
{
for (int i = 0; i < Dttemp.Rows.Count; i++)
{
Int32 GrIdno = 0;
GrIdno = Convert.ToInt32(GrIdnos[i + 1]);
TblGrHead objTblGrHead = (from obj1 in db.TblGrHeads where obj1.GR_Idno == GrIdno select obj1).FirstOrDefault();
objTblGrHead.Chln_Idno = chlnBookId;
db.SaveChanges();
}
}
}
}
return(chlnBookId);
}
public Int64 Insert(tblChlnBookHead ChallanBookHead, List <tblChlnBookDetl> ChallanBookDetl)
{
Int64 ChallanBookHeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
tblChlnBookHead RH = db.tblChlnBookHeads.Where(rh => rh.Chln_No == ChallanBookHead.Chln_No).FirstOrDefault();
if (RH != null)
{
ChallanBookHeadId = -1;
}
else
{
db.tblChlnBookHeads.AddObject(ChallanBookHead);
db.SaveChanges();
ChallanBookHeadId = ChallanBookHead.Chln_Idno;
if (ChallanBookDetl.Count > 0)
{
foreach (tblChlnBookDetl rgd in ChallanBookDetl)
{
rgd.ChlnBookHead_Idno = ChallanBookHeadId;
db.tblChlnBookDetls.AddObject(rgd);
db.SaveChanges();
}
dbTran.Commit();
}
}
}
catch
{
dbTran.Rollback();
}
}
}
return(ChallanBookHeadId);
}
public int DeleteChallanDetail(Int64 HeadId)
{
int value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblChlnBookHead rgh = db.tblChlnBookHeads.Where(h => h.Chln_Idno == HeadId).FirstOrDefault();
List <tblChlnBookDetl> rgd = db.tblChlnBookDetls.Where(d => d.ChlnBookHead_Idno == HeadId).ToList();
if (rgh != null)
{
foreach (var d in rgd)
{
db.tblChlnBookDetls.DeleteObject(d);
db.SaveChanges();
}
db.tblChlnBookHeads.DeleteObject(rgh);
db.SaveChanges();
value = 1;
}
}
return(value);
}
private void Populate(Int64 HeadId)
{
ChlnBookingCrsngDAL obj = new ChlnBookingCrsngDAL();
tblChlnBookHead chlnBookhead = obj.selectHead(HeadId);
ddldateRange.SelectedValue = Convert.ToString(chlnBookhead.Year_Idno);
ddldateRange_SelectedIndexChanged(null, null);
ddldateRange.Enabled = false;
txtchallanNo.Text = chlnBookhead.Chln_No;
txtDate.Text = Convert.ToDateTime(chlnBookhead.Chln_Date).ToString("dd-MM-yyyy");
ddlTranspoter.SelectedValue = Convert.ToString(chlnBookhead.Transprtr_Idno);
txtchlnRef.Text = Convert.ToString(chlnBookhead.Ref_No);
ddlTruckNo.SelectedValue = Convert.ToString(chlnBookhead.Truck_Idno);
ddlTruckNo_SelectedIndexChanged(null, null);
txtgrossAmnt.Text = Convert.ToDouble(chlnBookhead.Gross_Amnt).ToString("N2");
txtKattAmnt.Text = Convert.ToDouble(chlnBookhead.Other_Amnt).ToString("N2");
txtNetAmnt.Text = Convert.ToDouble(chlnBookhead.Net_Amnt).ToString("N2");
hidWorkType.Value = Convert.ToString(chlnBookhead.Work_type);
DdlfromcityHead.SelectedValue = Convert.ToString(chlnBookhead.BaseCity_Idno);
dtTemp = obj.selectDetl(ApplicationFunction.ConnectionString(), Convert.ToInt32(ddldateRange.SelectedValue), HeadId);
ViewState["dt"] = dtTemp;
this.BindGridT();
// imgSearch.Enabled = false;
Int64 value = 0;
value = obj.CheckBilled(HeadId, ApplicationFunction.ConnectionString());
if (value > 0)
{
lnkbtnSave.Enabled = false;
}
else
{
lnkbtnSave.Enabled = true;
}
obj = null;
}
public int Delete(Int64 HeadId)
{
int value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblTripHead CH = db.tblTripHeads.Where(h => h.Trip_Idno == HeadId).FirstOrDefault();
List <tblChlnBookDetl> CD = db.tblChlnBookDetls.Where(d => d.ChlnBookHead_Idno == HeadId).ToList();
List <tblTripChlnDetl> TD = db.tblTripChlnDetls.Where(d => d.TripHead_Idno == HeadId).ToList();
if (CH != null)
{
List <tblTripChlnDetl> ChlnDetl = db.tblTripChlnDetls.Where(rd => rd.TripHead_Idno == HeadId).ToList();
foreach (var d in ChlnDetl)
{
db.tblTripChlnDetls.DeleteObject(d);
db.SaveChanges();
}
List <tblTripFuelDetl> FuelDetl = db.tblTripFuelDetls.Where(rd => rd.TripHead_Idno == HeadId).ToList();
foreach (var d in FuelDetl)
{
db.tblTripFuelDetls.DeleteObject(d);
db.SaveChanges();
}
List <tblTripExpDetl> ExpDetl = db.tblTripExpDetls.Where(rd => rd.TripHead_Idno == HeadId).ToList();
foreach (var d in ExpDetl)
{
db.tblTripExpDetls.DeleteObject(d);
db.SaveChanges();
}
List <tblTripTollDetl> TollDetl = db.tblTripTollDetls.Where(rd => rd.TripHead_Idno == HeadId).ToList();
foreach (var d in TollDetl)
{
db.tblTripTollDetls.DeleteObject(d);
db.SaveChanges();
}
foreach (var d in TD)
{
tblChlnBookHead objChlnHead = (from obj in db.tblChlnBookHeads where obj.Chln_Idno == d.Chln_Idno select obj).FirstOrDefault();
objChlnHead.Trip_Billed = false;
db.SaveChanges();
}
db.tblTripHeads.DeleteObject(CH);
db.SaveChanges();
int intValue = 1;
if (intValue > 0)
{
value = 1;
}
}
}
}
catch (Exception ex)
{
value = -1;
}
return(value);
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
#region Validation Messages for Challan Details
if (ddlTranspoter.SelectedIndex == 0)
{
this.ShowMessage("Please select Transporter."); ddlTranspoter.Focus(); return;
}
if (ddlTruckNo.SelectedIndex == 0)
{
this.ShowMessage("Please select Truck No."); ddlTruckNo.Focus(); return;
}
if (txtchlnRef.Text == "")
{
this.ShowMessage("Please Enter Challan Ref.No ."); ddlTruckNo.Focus(); return;
}
string msg = "";
dtTemp = (DataTable)ViewState["dt"];
if (dtTemp != null)
{
if (dtTemp.Rows.Count <= 0)
{
ShowMessage("Please enter details");
return;
}
}
if (grdMain.Rows.Count <= 0)
{
ShowMessage("Please enter details");
return;
}
#endregion
#region Declare Input Variables for Challan Details
//string strMsg = string.Empty;
//Int64 intGrPrepIdno = 0;
//Int32 YearIdno = Convert.ToInt32(ddldateRange.SelectedValue) == -1 ? 0 : Convert.ToInt32(ddldateRange.SelectedValue);
//DateTime strChallanDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text.Trim().ToString()));
//Int64 intChallanNo = string.IsNullOrEmpty(txtchallanNo.Text.Trim()) ? 0 : Convert.ToInt64(txtchallanNo.Text.Trim());
//Int32 intTranspoter = string.IsNullOrEmpty(ddlTranspoter.SelectedValue) ? 0 : Convert.ToInt32(ddlTranspoter.SelectedValue);
//Int32 TruckNoIdno = string.IsNullOrEmpty(ddlTruckNo.SelectedValue) ? 0 : Convert.ToInt32(ddlTruckNo.SelectedValue);
//Int32 strChlnRefno = string.IsNullOrEmpty(txtchlnRef.Text) ? 0 : Convert.ToInt32(txtchlnRef.Text);
//DateTime? dtInstDate;
//if (txtInstDate.Text == "")
//{
// dtInstDate = null;
//}
//else
//{
// dtInstDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtInstDate.Text));
//}
#endregion
#region Insert/Update with Transaction
using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
{
string intGrPrepIdno = "";
string ChlnNo = txtchallanNo.Text;
Int32 TrunckIdno = Convert.ToInt32(ddlTruckNo.SelectedValue);
Int32 YearIdno = Convert.ToInt32((ddldateRange.SelectedIndex < 0) ? "0" : ddldateRange.SelectedValue);
GRPrepDAL objDAL = new GRPrepDAL();
isTBBRate = objDAL.SelectTBBRate();
tblUserPref userpref = objDAL.selectuserpref();
itruckcitywise = Convert.ToInt32(userpref.Work_Type);
DataTable dtDetail = (DataTable)ViewState["dt"];
try
{
ChlnBookingCrsngDAL obj = new ChlnBookingCrsngDAL();
tblChlnBookHead objtblChlnBookHead = new tblChlnBookHead();
objtblChlnBookHead.Chln_No = txtchallanNo.Text;
objtblChlnBookHead.Chln_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text));
objtblChlnBookHead.BaseCity_Idno = Convert.ToInt32((DdlfromcityHead.SelectedIndex <= 0) ? "0" : DdlfromcityHead.SelectedValue);
objtblChlnBookHead.DelvryPlc_Idno = Convert.ToInt32(0);
objtblChlnBookHead.Truck_Idno = Convert.ToInt32((ddlTruckNo.SelectedIndex <= 0) ? "0" : ddlTruckNo.SelectedValue);
objtblChlnBookHead.Year_Idno = Convert.ToInt32((ddldateRange.SelectedIndex < 0) ? "0" : ddldateRange.SelectedValue);
objtblChlnBookHead.Driver_Idno = Convert.ToInt32(1);
objtblChlnBookHead.Delvry_Instrc = "";
objtblChlnBookHead.Inv_Idno = 0;
objtblChlnBookHead.Gross_Amnt = Convert.ToDouble(txtgrossAmnt.Text);
objtblChlnBookHead.Commsn_Amnt = Convert.ToDouble(0.00);
objtblChlnBookHead.Transprtr_Idno = Convert.ToInt32(ddlTranspoter.SelectedValue);
objtblChlnBookHead.Chln_type = 2;
objtblChlnBookHead.Net_Amnt = Convert.ToDouble(txtNetAmnt.Text);
objtblChlnBookHead.Other_Amnt = Convert.ToDouble(txtKattAmnt.Text);
objtblChlnBookHead.Work_type = Convert.ToInt32(hidWorkType.Value);
objtblChlnBookHead.Ref_No = Convert.ToString(txtchlnRef.Text);
objtblChlnBookHead.Adv_Amnt = Convert.ToDouble(0.00);
objtblChlnBookHead.RcptType_Idno = Convert.ToInt32(1);
objtblChlnBookHead.Bank_Idno = Convert.ToInt32(0);
objtblChlnBookHead.Inst_No = Convert.ToInt32(0);
objtblChlnBookHead.Inst_Dt = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text));
objtblChlnBookHead.Date_Added = Convert.ToDateTime(DateTime.Now);
Int64 value = 0;
if (string.IsNullOrEmpty(hidid.Value) == true)
{
if (grdMain.Rows.Count > 0 && dtTemp != null && dtTemp.Rows.Count > 0)
{
ChlnBookingCrsngDAL obj1 = new ChlnBookingCrsngDAL();
intGrPrepIdno = obj1.InsertGR(ChlnNo, TrunckIdno, YearIdno, isTBBRate, itruckcitywise, dtDetail);
obj1 = null;
}
value = obj.Insert(objtblChlnBookHead, dtTemp, intGrPrepIdno);
// obj = null;
}
else
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
Int32 ChlnIdno = Convert.ToInt32(hidid.Value);
TblGrHead GrHEad = db.TblGrHeads.Where(rd => rd.Chln_Idno == ChlnIdno).FirstOrDefault();
List <TblGrDetl> GrDetl = db.TblGrDetls.Where(rd => rd.GrHead_Idno == GrHEad.GR_Idno).ToList();
foreach (TblGrDetl rgd in GrDetl)
{
db.TblGrDetls.DeleteObject(rgd);
db.SaveChanges();
}
db.TblGrHeads.DeleteObject(GrHEad);
db.SaveChanges();
db.Connection.Close();
}
if (grdMain.Rows.Count > 0 && dtTemp != null && dtTemp.Rows.Count > 0)
{
ChlnBookingCrsngDAL obj1 = new ChlnBookingCrsngDAL();
intGrPrepIdno = obj1.InsertGR(ChlnNo, TrunckIdno, YearIdno, isTBBRate, itruckcitywise, dtDetail);
obj1 = null;
}
value = obj.Update(objtblChlnBookHead, Convert.ToInt32(hidid.Value), dtTemp, intGrPrepIdno);
}
if (value > 0)
{
tScope.Complete();
}
if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == false))
{
ShowMessage("Record Update successfully");
Response.Redirect("ChlnBookingCrsng.aspx", false);
}
else if (value == -1)
{
ShowMessage("Challan No Already Exist");
}
else
{
ShowMessage("Record Not Update");
}
if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == true))
{
ShowMessage("Record saved Successfully ");
Response.Redirect("ChlnBookingCrsng.aspx", false);
}
else if (value == -1)
{
tScope.Dispose();
ShowMessage("Challan No Already Exist");
}
else
{
ShowMessage("Record Not saved Successfully ");
}
}
catch (Exception Ex)
{
tScope.Dispose();
}
#endregion
}
}
public Int64 Update(tblChlnBookHead obj, Int32 ChlnIdno, DataTable Dttemp, string GrHeadsIdno)
{
Int64 chlnBoookId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
tblChlnBookHead CH = db.tblChlnBookHeads.Where(rh => rh.Chln_No == obj.Chln_No && (rh.Chln_Idno != ChlnIdno) && (rh.Year_Idno == obj.Year_Idno) && (rh.BaseCity_Idno == obj.BaseCity_Idno) && (rh.Chln_type == 2)).FirstOrDefault();
if (CH != null)
{
chlnBoookId = -1;
}
else
{
tblChlnBookHead TBH = db.tblChlnBookHeads.Where(rh => rh.Chln_Idno == ChlnIdno).FirstOrDefault();
if (TBH != null)
{
TBH.Chln_No = obj.Chln_No;
TBH.Chln_Date = obj.Chln_Date;
TBH.BaseCity_Idno = obj.BaseCity_Idno;
TBH.DelvryPlc_Idno = obj.DelvryPlc_Idno;
TBH.Truck_Idno = obj.Truck_Idno;
TBH.Year_Idno = obj.Year_Idno;
TBH.Chln_type = obj.Chln_type;
TBH.Driver_Idno = obj.Driver_Idno;
TBH.Delvry_Instrc = obj.Delvry_Instrc;
TBH.Inv_Idno = obj.Inv_Idno;
TBH.Gross_Amnt = obj.Gross_Amnt;
TBH.Commsn_Amnt = obj.Commsn_Amnt;
TBH.Other_Amnt = obj.Other_Amnt;
TBH.Net_Amnt = obj.Net_Amnt;
TBH.Work_type = obj.Work_type;
TBH.Adv_Amnt = obj.Adv_Amnt;
TBH.RcptType_Idno = obj.RcptType_Idno;
TBH.Inst_No = obj.Inst_No;
TBH.Inst_Dt = obj.Inst_Dt;
TBH.Bank_Idno = obj.Bank_Idno;
db.SaveChanges();
chlnBoookId = TBH.Chln_Idno;
List <tblChlnBookDetl> ChlnDetl = db.tblChlnBookDetls.Where(rd => rd.ChlnBookHead_Idno == ChlnIdno).ToList();
foreach (tblChlnBookDetl rgd in ChlnDetl)
{
db.tblChlnBookDetls.DeleteObject(rgd);
db.SaveChanges();
}
//foreach (tblChlnBookDetl rgd in ChlnDetl)
//{
// rgd.ChlnBookHead_Idno = chlnBoookId;
// db.tblChlnBookDetls.AddObject(rgd);
// db.SaveChanges();
//}
string[] GrIdnos = GrHeadsIdno.Split(new string[] { "," }, StringSplitOptions.None);
if (Dttemp.Rows.Count > 0)
{
for (int i = 0; i < Dttemp.Rows.Count; i++)
{
tblChlnBookDetl objtblChlnBookDetl = new tblChlnBookDetl();
objtblChlnBookDetl.GR_Idno = Convert.ToInt32(GrIdnos[i + 1]);
objtblChlnBookDetl.DelvryPlce_Idno = Convert.ToInt32(Dttemp.Rows[i]["ToCityIdno"]);
objtblChlnBookDetl.ChlnBookHead_Idno = ChlnIdno;
db.tblChlnBookDetls.AddObject(objtblChlnBookDetl);
db.SaveChanges();
}
}
if (Dttemp.Rows.Count > 0)
{
for (int i = 0; i < Dttemp.Rows.Count; i++)
{
Int32 GrIdno = 0;
GrIdno = Convert.ToInt32(GrIdnos[i + 1]);
TblGrHead objTblGrHead = (from obj1 in db.TblGrHeads where obj1.GR_Idno == GrIdno select obj1).FirstOrDefault();
objTblGrHead.Chln_Idno = ChlnIdno;
db.SaveChanges();
}
}
dbTran.Commit();
}
}
}
catch
{
dbTran.Rollback();
}
}
}
return(chlnBoookId);
}
public Int64 Insert(tblInvGenHead obj, DataTable DtTemp, string GrType)
{
Int64 InvIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblChlnBookHead CHead = new tblChlnBookHead();
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
tblInvGenHead RH = db.tblInvGenHeads.Where(rh => rh.Inv_No == obj.Inv_No && rh.Inv_prefix == obj.Inv_prefix && rh.BaseCity_Idno == obj.BaseCity_Idno && rh.Year_Idno == obj.Year_Idno).FirstOrDefault();
if (RH != null)
{
InvIdno = -1;
}
else
{
obj.Date_Added = DateTime.Now;
obj.Date_Modified = DateTime.Now;
db.tblInvGenHeads.AddObject(obj);
db.SaveChanges();
InvIdno = obj.Inv_Idno;
if (DtTemp.Rows.Count > 0)
{
foreach (DataRow Dr in DtTemp.Rows)
{
tblInvGenDetl objtblInvGenDetl = new tblInvGenDetl();
objtblInvGenDetl.InvGenHead_Idno = InvIdno;
objtblInvGenDetl.GR_Idno = Convert.ToInt64(Dr["GR_Idno"]);
objtblInvGenDetl.Item_Idno = Convert.ToInt64(Dr["Item_Idno"]);
objtblInvGenDetl.Item_Rate = Convert.ToDouble(Dr["Item_Rate"]);
objtblInvGenDetl.Unit_Idno = Convert.ToInt64(Dr["Unit_Idno"]);
objtblInvGenDetl.Amount = Convert.ToDouble(Dr["Amount"]);
objtblInvGenDetl.Wayges = Convert.ToDouble(Dr["Wayges"]);
objtblInvGenDetl.Net_Amnt = Convert.ToDouble(Dr["Net_Amnt"]);
objtblInvGenDetl.Other_Amnt = Convert.ToDouble(Dr["Other_Amnt"]);
objtblInvGenDetl.ServTax_Amnt = Convert.ToDouble(Dr["ServTax_Amnt"]);
objtblInvGenDetl.ServTax_Perc = Convert.ToDouble(Dr["ServTax_Perc"]);
objtblInvGenDetl.ServTax_Valid = Convert.ToDouble(Dr["ServTax_Valid"]);
objtblInvGenDetl.SwchBrtTax_Amnt = Convert.ToDouble(Dr["SwchBrtTax_Amnt"]);
objtblInvGenDetl.KisanTax_Amnt = Convert.ToDouble(Dr["KisanKalyan_Amnt"]);
//#GST
objtblInvGenDetl.SGST_Amt = Convert.ToDouble(Dr["SGST_Amt"]);
objtblInvGenDetl.CGST_Amt = Convert.ToDouble(Dr["CGST_Amt"]);
objtblInvGenDetl.IGST_Amt = Convert.ToDouble(Dr["IGST_Amt"]);
objtblInvGenDetl.Annexure_No = Convert.ToString(Dr["Annexure_No"]);
db.tblInvGenDetls.AddObject(objtblInvGenDetl);
db.SaveChanges();
}
}
if (DtTemp.Rows.Count > 0)
{
if (GrType == "GR")
{
foreach (DataRow Dr in DtTemp.Rows)
{
Int32 GrIdno = Convert.ToInt32(Dr["GR_Idno"]);
TblGrHead objTblGrHead = (from obj1 in db.TblGrHeads where obj1.GR_Idno == GrIdno select obj1).FirstOrDefault();
objTblGrHead.Billed = true;
db.SaveChanges();
}
}
else
{
foreach (DataRow Dr in DtTemp.Rows)
{
Int32 GrIdno = Convert.ToInt32(Dr["GR_Idno"]);
tblGrRetailerHead objTblGrHead = (from obj1 in db.tblGrRetailerHeads where obj1.GRRetHead_Idno == GrIdno select obj1).FirstOrDefault();
objTblGrHead.Billed = true;
db.SaveChanges();
}
}
}
dbTran.Commit();
}
}
catch
{
dbTran.Rollback();
}
}
return(InvIdno);
}
}
