public Boolean UpdateGrHeadForKm(string ConString, Int64 GrId, double Frmkm, double Tokm, double Totkm)
{
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
TblGrHead objtblGrhead = (from obj in db.TblGrHeads where obj.GR_Idno == GrId select obj).FirstOrDefault();
if (objtblGrhead != null)
{
objtblGrhead.From_KM = Frmkm;
objtblGrhead.To_KM = Tokm;
objtblGrhead.Tot_KM = Totkm;
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception EX)
{
return(false);
}
}
public Int64 Updatebilled(Int64 GrIdno)
{
Int64 GrHeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
TblGrHead TBH = db.TblGrHeads.Where(rh => rh.GR_Idno == GrIdno).FirstOrDefault();
if (TBH != null)
{
TBH.Billed = false;
db.SaveChanges();
//GrHeadId = TBH.GR_Idno;
//List<tblInvGenDetl> InvDetl = db.tblInvGenDetls.Where(rd => rd.GR_Idno == GrIdno).ToList();
//foreach (tblInvGenDetl rgd in InvDetl)
//{
// db.tblInvGenDetls.DeleteObject(rgd);
// db.SaveChanges();
//}
dbTran.Commit();
}
}
// }
catch
{
dbTran.Rollback();
}
}
}
return(GrHeadId);
}
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 int DeleteGR(Int64 HeadId)
{
clsAccountPosting objclsAccountPosting = new clsAccountPosting();
int value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
TblGrHead qth = db.TblGrHeads.Where(h => h.GR_Idno == HeadId).FirstOrDefault();
List <TblGrDetl> qtd = db.TblGrDetls.Where(d => d.GrHead_Idno == HeadId).ToList();
if (qth != null)
{
foreach (var d in qtd)
{
db.TblGrDetls.DeleteObject(d);
db.SaveChanges();
}
db.TblGrHeads.DeleteObject(qth);
Int64 intValue = objclsAccountPosting.DeleteAccountPosting(HeadId, "GR");
db.SaveChanges();
value = 1;
}
}
return(value);
}
public Int64 UpdateMtrlRcptHOHead(tblChlnDelvHead objMtrlRcptHOHead, DataTable DtTemp, Int32 HeadIdno)
{
Int64 RcptHeadIdno = HeadIdno;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblChlnDelvHead RH = db.tblChlnDelvHeads.Where(rh => (rh.ChlnTransf_Idno == objMtrlRcptHOHead.ChlnTransf_Idno) && (rh.ToCity_Idno == objMtrlRcptHOHead.ToCity_Idno) && (rh.Year_Idno == objMtrlRcptHOHead.Year_Idno) && (rh.ChlnDelvHead_Idno != HeadIdno)).FirstOrDefault();
if (RH != null)
{
RcptHeadIdno = -1;
}
else
{
tblChlnDelvHead objRcptHOHead = (from obj in db.tblChlnDelvHeads
where obj.ChlnDelvHead_Idno == RcptHeadIdno
select obj).SingleOrDefault();
if (objRcptHOHead != null)
{
objRcptHOHead.ChlnDelv_Date = objMtrlRcptHOHead.ChlnDelv_Date;
objRcptHOHead.ToCity_Idno = objMtrlRcptHOHead.ToCity_Idno;
objRcptHOHead.ChlnTransf_Idno = objMtrlRcptHOHead.ChlnTransf_Idno;
objRcptHOHead.LocGR_Amnt = objMtrlRcptHOHead.LocGR_Amnt;
objRcptHOHead.CrsngGR_Amnt = objMtrlRcptHOHead.CrsngGR_Amnt;
objRcptHOHead.Net_Amnt = objMtrlRcptHOHead.Net_Amnt;
objRcptHOHead.Date_Modified = MultipleDBDAL.GetIndianDateTime().Date; // DateTime.Now.Date;
objRcptHOHead.Year_Idno = objMtrlRcptHOHead.Year_Idno;
db.SaveChanges();
}
List <tblChlnDelvDetl> ChlnDetl = db.tblChlnDelvDetls.Where(rd => rd.ChlnDelvHead_Idno == RcptHeadIdno).ToList();
foreach (tblChlnDelvDetl rgd in ChlnDetl)
{
db.tblChlnDelvDetls.DeleteObject(rgd);
db.SaveChanges();
}
if (DtTemp.Rows.Count > 0)
{
foreach (DataRow Dr in DtTemp.Rows)
{
tblChlnDelvDetl objtblChlnDelvDetl = new tblChlnDelvDetl();
objtblChlnDelvDetl.Gr_Idno = Convert.ToInt32(Dr["Gr_Idno"]);
objtblChlnDelvDetl.Item_Idno = Convert.ToInt32(Dr["Item_Idno"]);
objtblChlnDelvDetl.Unit_Idno = Convert.ToInt32(Dr["Unit_Idno"]);
objtblChlnDelvDetl.Rate_Type = Convert.ToInt32(Dr["Rate_Type"]);
objtblChlnDelvDetl.Qty = Convert.ToInt32(Dr["Qty"]);
objtblChlnDelvDetl.Weight = Convert.ToDouble(Dr["Weight"]);
objtblChlnDelvDetl.Amount = Convert.ToDouble(Dr["Amount"]);
objtblChlnDelvDetl.Reamrk = Convert.ToString(Dr["Reamrk"]);
objtblChlnDelvDetl.Delv_Qty = Convert.ToDouble(Dr["Delv_Qty"]);
objtblChlnDelvDetl.Delv_Weight = Convert.ToDouble(Dr["Delv_Wt"]);
objtblChlnDelvDetl.Delv_Amount = Convert.ToDouble(Dr["Delv_Amount"]);
objtblChlnDelvDetl.Reamrk = Convert.ToString(Dr["Reamrk"]);
objtblChlnDelvDetl.ChlnDelvHead_Idno = RcptHeadIdno;
db.tblChlnDelvDetls.AddObject(objtblChlnDelvDetl);
db.SaveChanges();
}
}
if (DtTemp.Rows.Count > 0)
{
foreach (DataRow Dr in DtTemp.Rows)
{
Int32 GrIdno = 0;
GrIdno = Convert.ToInt32(Dr["Gr_Idno"]);
TblGrHead objTblGrHead = (from obj in db.TblGrHeads where obj.GR_Idno == GrIdno select obj).FirstOrDefault();
if (objTblGrHead != null)
{
objTblGrHead.Gr_Delv = true;
objTblGrHead.ChlnDelv_Idno = RcptHeadIdno;
db.SaveChanges();
}
}
}
}
}
}
catch (Exception ex)
{
}
return(RcptHeadIdno);
}
public Int64 InsertMtrlRcptHOHead(tblChlnDelvHead objMtrlRcptHOHead, DataTable DtTemp)
{
Int64 RcptHeadIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
tblChlnDelvHead RH = db.tblChlnDelvHeads.Where(rh => (rh.ChlnTransf_Idno == objMtrlRcptHOHead.ChlnTransf_Idno) && (rh.ToCity_Idno == objMtrlRcptHOHead.ToCity_Idno)).FirstOrDefault();
if (RH != null)
{
RcptHeadIdno = -1;
}
else
{
db.tblChlnDelvHeads.AddObject(objMtrlRcptHOHead);
db.SaveChanges();
RcptHeadIdno = objMtrlRcptHOHead.ChlnDelvHead_Idno;
if (DtTemp.Rows.Count > 0)
{
foreach (DataRow Dr in DtTemp.Rows)
{
// ApplicationFunction.CreateTable("tbl", "Gr_Idno", "String", "Item_Idno", "String", "Unit_Idno", "String", "Rate_Type", "String", "Qty", "Weight", "", "String", "Amount", "String", "Delv_Qty", "String", "Reamrk", "String");
tblChlnDelvDetl objtblChlnDelvDetl = new tblChlnDelvDetl();
objtblChlnDelvDetl.Gr_Idno = Convert.ToInt32(Dr["Gr_Idno"]);
objtblChlnDelvDetl.Item_Idno = Convert.ToInt32(Dr["Item_Idno"]);
objtblChlnDelvDetl.Unit_Idno = Convert.ToInt32(Dr["Unit_Idno"]);
objtblChlnDelvDetl.Rate_Type = Convert.ToInt32(Dr["Rate_Type"]);
objtblChlnDelvDetl.Qty = Convert.ToInt32(Dr["Qty"]);
objtblChlnDelvDetl.Weight = Convert.ToDouble(Dr["Weight"]);
objtblChlnDelvDetl.Amount = Convert.ToDouble(Dr["Amount"]);
objtblChlnDelvDetl.Reamrk = Convert.ToString(Dr["Reamrk"]);
objtblChlnDelvDetl.Delv_Qty = Convert.ToDouble(Dr["Delv_Qty"]);
objtblChlnDelvDetl.Delv_Weight = Convert.ToDouble(Dr["Delv_Wt"]);
objtblChlnDelvDetl.Delv_Amount = Convert.ToDouble(Dr["Delv_Amount"]);
objtblChlnDelvDetl.Reamrk = Convert.ToString(Dr["Reamrk"]);
objtblChlnDelvDetl.ChlnDelvHead_Idno = RcptHeadIdno;
db.tblChlnDelvDetls.AddObject(objtblChlnDelvDetl);
db.SaveChanges();
}
}
if (DtTemp.Rows.Count > 0)
{
foreach (DataRow Dr in DtTemp.Rows)
{
Int32 GrIdno = 0;
GrIdno = Convert.ToInt32(Dr["Gr_Idno"]);
TblGrHead objTblGrHead = (from obj in db.TblGrHeads where obj.GR_Idno == GrIdno select obj).FirstOrDefault();
if (objTblGrHead != null)
{
objTblGrHead.Gr_Delv = true;
objTblGrHead.ChlnDelv_Idno = RcptHeadIdno;
db.SaveChanges();
}
}
}
}
}
catch
{
return(0);
}
return(RcptHeadIdno);
}
}
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 string InsertGR(string ChlnNo, Int32 TruckNoIdno, Int32 YearIdno, Boolean isTBBRate, Int32 itruckcitywise, DataTable dtDetail)
{
Int64 intGrIdno = 0;
string GrIdnos = "";
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
//using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
//{
try
{
TblGrHead objGRHead = null;
if (objGRHead == null)
{
foreach (DataRow row in dtDetail.Rows)
{
objGRHead = new TblGrHead();
objGRHead.Gr_Date = Convert.ToDateTime(row["GR_Date"]);
objGRHead.GR_Agnst = 1;
objGRHead.GR_Typ = Convert.ToInt32(row["Gr_TypeIdno"]);
objGRHead.DI_NO = "";
objGRHead.EGP_NO = "";
objGRHead.Gr_No = Convert.ToInt32(row["GR_No"]);
objGRHead.Lorry_Idno = TruckNoIdno;
objGRHead.Sender_Idno = Convert.ToInt64(row["SenderNameIdno"]);
objGRHead.Recivr_Idno = Convert.ToInt64(row["ReciverNameIdno"]);
objGRHead.From_City = Convert.ToInt64(row["FromCityIdno"]);
objGRHead.To_City = Convert.ToInt64(row["ToCityIdno"]);
objGRHead.DelvryPlce_Idno = 1;
objGRHead.Agnt_Idno = 0;
objGRHead.Remark = "Against Challan Crossing [ No." + ChlnNo + "]";
objGRHead.STax_Typ = 1;
objGRHead.RcptType_Idno = 1;
objGRHead.Inst_No = "";
objGRHead.Inst_Dt = Convert.ToDateTime(row["GR_Date"]);
objGRHead.Bank_Idno = 0;
objGRHead.Gross_Amnt = Convert.ToDouble(row["Amount"]);
objGRHead.AgntComisn_Amnt = 0.00;
objGRHead.TollTax_Amnt = 0.00;
objGRHead.Cartg_Amnt = 0.00;
objGRHead.Bilty_Amnt = 0.00;
objGRHead.SubTot_Amnt = 0.00;
objGRHead.Total_Amnt = Convert.ToDouble(row["Amount"]);
objGRHead.Wages_Amnt = 0.00;
objGRHead.ServTax_Amnt = 0.00;
objGRHead.Surcrg_Amnt = 0.00;
objGRHead.PF_Amnt = 0.00;
objGRHead.Net_Amnt = Convert.ToDouble(row["Amount"]);
objGRHead.RndOff_Amnt = 0.00;
objGRHead.Year_Idno = YearIdno;
objGRHead.TBB_Rate = isTBBRate;
objGRHead.cmb_type = itruckcitywise;
objGRHead.GR_Frm = "CC";
objGRHead.AgnstRcpt_No = "";
objGRHead.Chln_Idno = 0;
objGRHead.ChlnCrsng_Idno = 0;
objGRHead.Billed = false;
db.TblGrHeads.AddObject(objGRHead);
db.SaveChanges();
intGrIdno = objGRHead.GR_Idno;
if (intGrIdno > 0)
{
GrIdnos += "," + intGrIdno;
TblGrDetl objGRDetl = new TblGrDetl();
objGRDetl.GrHead_Idno = Convert.ToInt64(intGrIdno);
objGRDetl.Item_Idno = Convert.ToInt32(0);
objGRDetl.Unit_Idno = Convert.ToInt32(0);
objGRDetl.Rate_Type = Convert.ToInt32(1);
objGRDetl.Qty = Convert.ToInt64(row["Qty"]);
objGRDetl.Tot_Weght = Convert.ToDouble(row["Weight"]);
objGRDetl.Item_Rate = 0.00;
objGRDetl.Amount = Convert.ToDouble(row["Amount"]);
objGRDetl.Detail = Convert.ToString(row["Detail"]);
objGRDetl.Shrtg_Limit = Convert.ToDouble(0);
objGRDetl.Shrtg_Rate = Convert.ToDouble(0);
db.TblGrDetls.AddObject(objGRDetl);
db.SaveChanges();
}
}
// tScope.Complete();
}
else
{
GrIdnos = "";
}
}
catch (Exception Ex)
{
// tScope.Dispose();
GrIdnos = "";
}
}
//}
return(GrIdnos);
}
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 int Delete(Int64 HeadId, Int64 UserIdno, string con, string Grtype)
{
int value = 0; clsAccountPosting objclsAccountPosting = new clsAccountPosting();
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblInvGenHead CH = db.tblInvGenHeads.Where(h => h.Inv_Idno == HeadId).FirstOrDefault();
List <tblInvGenDetl> CD = db.tblInvGenDetls.Where(d => d.InvGenHead_Idno == HeadId).ToList();
if (CD != null && CH != null)
{
var lst = (from AI in db.tblAmntRecvInv_Detl where AI.Inv_Idno == HeadId select AI).ToList();
if (lst != null && lst.Count > 0)
{
return(-1);
}
else
{
if (CH != null)
{
SqlParameter[] objSqlPara = new SqlParameter[3];
objSqlPara[0] = new SqlParameter("@Action", "DeleteInvoiceDetails");
objSqlPara[1] = new SqlParameter("@Idno", HeadId);
objSqlPara[2] = new SqlParameter("@UserIdno", UserIdno);
Int32 del = SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "spDeleteFunctionality", objSqlPara);
if (Grtype == "GR")
{
foreach (var d in CD)
{
TblGrHead objTblGrHead = (from obj in db.TblGrHeads where obj.GR_Idno == d.GR_Idno select obj).FirstOrDefault();
objTblGrHead.Billed = false;
db.SaveChanges();
}
}
else
{
foreach (var d in CD)
{
tblGrRetailerHead objtblGrRetailerHead = (from obj in db.tblGrRetailerHeads where obj.GRRetHead_Idno == d.GR_Idno select obj).FirstOrDefault();
objtblGrRetailerHead.Billed = false;
db.SaveChanges();
}
}
foreach (var d in CD)
{
db.tblInvGenDetls.DeleteObject(d);
db.SaveChanges();
}
db.tblInvGenHeads.DeleteObject(CH);
db.SaveChanges();
Int64 intValue = objclsAccountPosting.DeleteAccountPosting(HeadId, "IB");
db.SaveChanges();
if (intValue > 0)
{
value = 1;
}
}
}
}
}
return(value);
}
public Int64 Update(tblInvGenHead obj, Int32 InvIdno, DataTable DtTemp, string Grtype)
{
Int64 InvHeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
//tblInvGenHead CH = db.tblInvGenHeads.Where(rh => rh.Inv_No == obj.Inv_No && rh.Inv_Idno != InvIdno && rh.Inv_prefix == obj.Inv_prefix && rh.BaseCity_Idno == obj.BaseCity_Idno).FirstOrDefault();
//if (CH != null)
//{
// InvHeadId = -1;
//}
//else
//{
tblInvGenHead TBH = db.tblInvGenHeads.Where(rh => rh.Inv_Idno == InvIdno).FirstOrDefault();
if (TBH != null)
{
TBH.Inv_No = obj.Inv_No;
TBH.Inv_prefix = obj.Inv_prefix;
TBH.Inv_Date = obj.Inv_Date;
TBH.Sendr_Idno = obj.Sendr_Idno;
TBH.BaseCity_Idno = obj.BaseCity_Idno;
TBH.Year_Idno = obj.Year_Idno;
TBH.GrossTot_Amnt = obj.GrossTot_Amnt;
TBH.ServTax_Amnt = obj.ServTax_Amnt;
TBH.Short_Amnt = obj.Short_Amnt;
TBH.Net_Amnt = obj.Net_Amnt;
TBH.Bilty_Chrgs = obj.Bilty_Chrgs;
TBH.TBB_Rate = obj.TBB_Rate;
TBH.TrServTax_Amnt = obj.TrServTax_Amnt;
TBH.TrSwchBrtTax_Amnt = obj.TrSwchBrtTax_Amnt;
TBH.ConsignrServTax = obj.ConsignrServTax;
TBH.TrKisanKalyanTax_Amnt = obj.TrKisanKalyanTax_Amnt;
TBH.ConsignrKisanTax_Amnt = obj.ConsignrKisanTax_Amnt;
TBH.RoundOff_Amnt = obj.RoundOff_Amnt;
TBH.Admin_Approval = obj.Admin_Approval;
TBH.Print_Format = obj.Print_Format;
TBH.Plant_InDate = obj.Plant_InDate;
TBH.Plant_OutDate = obj.Plant_OutDate;
TBH.Port_InDate = obj.Port_InDate;
TBH.Port_OutDate = obj.Port_OutDate;
TBH.PlantAmount = obj.PlantAmount;
TBH.PortAmount = obj.PortAmount;
TBH.PortDays = obj.PortDays;
TBH.PlantDays = obj.PlantDays;
TBH.HQCharges_Amnt = obj.HQCharges_Amnt;
TBH.AddCharges_Amnt = obj.AddCharges_Amnt;
TBH.Charges1_Name = obj.Charges1_Name;
TBH.Charges1_Amnt = obj.Charges1_Amnt;
TBH.Charges2_Name = obj.Charges2_Name;
TBH.Charges2_Amnt = obj.Charges2_Amnt;
TBH.Date_Modified = DateTime.Now;
TBH.ShtgGST_Amt = obj.ShtgGST_Amt;
TBH.User_ModifiedBy = obj.User_ModifiedBy;
TBH.Delivery_Add = obj.Delivery_Add;
db.SaveChanges();
InvHeadId = TBH.Inv_Idno;
List <tblInvGenDetl> InvDetl = db.tblInvGenDetls.Where(rd => rd.InvGenHead_Idno == InvIdno).ToList();
foreach (tblInvGenDetl rgd in InvDetl)
{
db.tblInvGenDetls.DeleteObject(rgd);
db.SaveChanges();
}
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"]);
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(InvHeadId);
}
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);
}
}
