public int Delete(Int64 HeadId)
{
int value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblDelvChlnHead CH = db.tblDelvChlnHeads.Where(h => h.DelvChln_Idno == HeadId).FirstOrDefault();
List <tblDelvChlnDetl> CD = db.tblDelvChlnDetls.Where(d => d.DelvChlnHead_Idno == HeadId).ToList();
if (CH != null)
{
foreach (var d in CD)
{
tblChlnDelvDetl objTblchln = (from obj in db.tblChlnDelvDetls where obj.Gr_Idno == d.GR_Idno select obj).FirstOrDefault();
objTblchln.DelvChlnHead_Idno = 0;
db.SaveChanges();
}
foreach (var d in CD)
{
db.tblDelvChlnDetls.DeleteObject(d);
db.SaveChanges();
}
db.tblDelvChlnHeads.DeleteObject(CH);
// Int64 intValue = objclsAccountPosting.DeleteAccountPosting(HeadId, "CB");
db.SaveChanges();
value = 1;
}
}
return(value);
}
private void Populate(Int64 HeadId)
{
imgSearch.Enabled = false;
ddlDelvryPlace.Enabled = false;
DeliveryChallanDetailsDAL obj = new DeliveryChallanDetailsDAL();
tblDelvChlnHead chlnhead = obj.selectHead(HeadId);
ddldateRange.SelectedValue = Convert.ToString(chlnhead.Year_Idno);
ddldateRange_SelectedIndexChanged(null, null);
ddldateRange.Enabled = false;
txtchallanNo.Text = Convert.ToString(chlnhead.DelvChln_No);
txtDate.Text = Convert.ToDateTime(chlnhead.DelvChln_Date).ToString("dd-MM-yyyy");
ddlDelvryPlace.SelectedValue = Convert.ToString(chlnhead.DelvryPlc_Idno);
ddlTransportName.SelectedValue = Convert.ToString(chlnhead.Transprtr_Idno);
ddlTruckNo.SelectedValue = Convert.ToString(chlnhead.Truck_Idno);
ddlTruckNo_SelectedIndexChanged(null, null);
ddldriverName.SelectedValue = Convert.ToString(chlnhead.Driver_Idno);
txtDelvInstruction.Text = Convert.ToString(chlnhead.Delvry_Instrc);
txtkatt.Text = Convert.ToDouble(chlnhead.Katt_Amnt).ToString("N2");
txtNetAmnt.Text = Convert.ToDouble(chlnhead.Net_Amnt).ToString("N2");
txtOtherAmnt.Text = Convert.ToDouble(chlnhead.Other_Amnt).ToString("N2");
txtGrosstotal.Text = Convert.ToDouble(chlnhead.Gross_Amnt).ToString("N2");
//if (Convert.ToInt32(hidWorkType.Value) > 1)
//{
// ddlDelvryPlace.Visible = false;
// ddlTruckNo.Enabled = false;
//}
//else
//{
// ddlDelvryPlace.Visible = true;
// ddlTruckNo.Enabled = true;
// ddlDelvryPlace.Enabled = false;
//}
DtTemp = obj.selectDetl(ApplicationFunction.ConnectionString(), Convert.ToInt32(ddldateRange.SelectedValue), HeadId);
ViewState["dt"] = DtTemp;
this.BindGrid();
imgSearch.Enabled = false;
Int64 value = 0;
value = obj.CheckBilled(HeadId, ApplicationFunction.ConnectionString());
if (value > 0)
{
lnkbtnSave.Enabled = false;
}
else
{
lnkbtnSave.Enabled = true;
}
PrintChallan(HeadId);
obj = null;
}
public Int64 Insert(tblDelvChlnHead obj, DataTable Dttemp, Int32 DelvPlcIdno, string ConnString)
{
Int64 chlnBookId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
tblDelvChlnHead RH = db.tblDelvChlnHeads.Where(rh => (rh.DelvChln_No == obj.DelvChln_No) && (rh.Year_Idno == obj.Year_Idno)).FirstOrDefault();
if (RH != null)
{
chlnBookId = -1;
}
else
{
db.tblDelvChlnHeads.AddObject(obj);
db.SaveChanges();
chlnBookId = obj.DelvChln_Idno;
if (Dttemp.Rows.Count > 0)
{
foreach (DataRow Dr in Dttemp.Rows)
{
tblDelvChlnDetl objtblChlnDetl = new tblDelvChlnDetl();
objtblChlnDetl.DelvChlnHead_Idno = chlnBookId;
objtblChlnDetl.GR_Idno = Convert.ToInt32(Dr["Gr_Idno"]);
objtblChlnDetl.Delivered = false;
db.tblDelvChlnDetls.AddObject(objtblChlnDetl);
db.SaveChanges();
}
}
if (Dttemp.Rows.Count > 0)
{
foreach (DataRow Dr in Dttemp.Rows)
{
string StrQuery = "Update tblchlndelvdetl set DelvChlnHead_Idno=" + chlnBookId + " where Gr_idno=" + Convert.ToInt32(Dr["Gr_Idno"]) + "";
SqlHelper.ExecuteNonQuery(ConnString, CommandType.Text, StrQuery);
}
}
}
}
catch
{
}
}
return(chlnBookId);
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
string msg = "";
DtTemp = (DataTable)ViewState["dt"];
if (DtTemp != null)
{
if (DtTemp.Rows.Count <= 0)
{
ShowMessageErr("Please enter details");
return;
}
}
if (grdMain.Rows.Count <= 0)
{
ShowMessageErr("Please enter details");
return;
}
Int64 RateIdno = 0; bool isinsert = false;
DeliveryChallanDetailsDAL obj = new DeliveryChallanDetailsDAL();
tblDelvChlnHead objChlnDelvHead = new tblDelvChlnHead();
objChlnDelvHead.DelvChln_No = Convert.ToInt64(txtchallanNo.Text);
objChlnDelvHead.DelvChln_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text));
objChlnDelvHead.DelvryPlc_Idno = Convert.ToInt32((ddlDelvryPlace.SelectedIndex <= 0) ? "0" : ddlDelvryPlace.SelectedValue);
objChlnDelvHead.Truck_Idno = Convert.ToInt32((ddlTruckNo.SelectedIndex <= 0) ? "0" : ddlTruckNo.SelectedValue);
objChlnDelvHead.Year_Idno = Convert.ToInt32((ddldateRange.SelectedIndex < 0) ? "0" : ddldateRange.SelectedValue);
objChlnDelvHead.Driver_Idno = Convert.ToInt32((ddldriverName.SelectedIndex <= 0) ? "0" : ddldriverName.SelectedValue);
objChlnDelvHead.Delvry_Instrc = txtDelvInstruction.Text.Trim().Replace("'", "");
objChlnDelvHead.Transprtr_Idno = Convert.ToInt32((ddlTransportName.SelectedIndex <= 0) ? "0" : ddlTransportName.SelectedValue);
objChlnDelvHead.Inv_Idno = 0;
objChlnDelvHead.Gross_Amnt = Convert.ToDouble(txtGrosstotal.Text);
objChlnDelvHead.Katt_Amnt = Convert.ToDouble(txtkatt.Text);
objChlnDelvHead.DelvChln_type = 1;
objChlnDelvHead.Other_Amnt = Convert.ToDouble(txtOtherAmnt.Text);
objChlnDelvHead.Net_Amnt = Convert.ToDouble(txtNetAmnt.Text);
objChlnDelvHead.Date_Added = Convert.ToDateTime(DateTime.Now);
Int64 value = 0;
using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
{
if (string.IsNullOrEmpty(hidid.Value) == true)
{
value = obj.Insert(objChlnDelvHead, DtTemp, Convert.ToInt32(ddlDelvryPlace.SelectedValue), ApplicationFunction.ConnectionString());
tScope.Complete();
obj = null;
}
else
{
value = obj.Update(objChlnDelvHead, Convert.ToInt32(hidid.Value), DtTemp, Convert.ToInt32(txtchallanNo.Text), ApplicationFunction.ConnectionString());
tScope.Complete();
}
if ((string.IsNullOrEmpty(hidid.Value) == false))
{
if (value > 0)
{
ShowMessage("Record Update successfully");
Clear();
}
else if (value == -1)
{
ShowMessageErr("Challan No Already Exist");
}
else
{
ShowMessageErr("Record Not Update");
}
}
else if (string.IsNullOrEmpty(hidid.Value) == true)
{
if (value > 0)
{
ShowMessage("Record saved Successfully ");
Clear();
}
else if (value == -1)
{
ShowMessageErr("Challan No Already Exist");
}
else
{
ShowMessageErr("Record Not saved Successfully ");
}
}
}
}
public Int64 Update(tblDelvChlnHead obj, Int32 ChlnIdno, DataTable Dttemp, Int64 Delvno, string ConnString)
{
Int64 chlnBoookId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
try
{
tblDelvChlnHead CH = db.tblDelvChlnHeads.Where(rh => rh.DelvChln_No == Delvno && (rh.DelvChln_Idno != ChlnIdno) && (rh.Year_Idno == obj.Year_Idno)).FirstOrDefault();
if (CH != null)
{
chlnBoookId = -1;
}
else
{
tblDelvChlnHead TBH = db.tblDelvChlnHeads.Where(rh => rh.DelvChln_Idno == ChlnIdno).FirstOrDefault();
if (TBH != null)
{
TBH.DelvChln_No = obj.DelvChln_No;
TBH.DelvChln_Date = obj.DelvChln_Date;
TBH.DelvryPlc_Idno = obj.DelvryPlc_Idno;
TBH.Truck_Idno = obj.Truck_Idno;
TBH.Year_Idno = obj.Year_Idno;
TBH.Driver_Idno = obj.Driver_Idno;
TBH.Delvry_Instrc = obj.Delvry_Instrc;
TBH.Transprtr_Idno = obj.Transprtr_Idno;
TBH.Inv_Idno = obj.Inv_Idno;
TBH.Gross_Amnt = obj.Gross_Amnt;
TBH.Other_Amnt = obj.Other_Amnt;
TBH.Net_Amnt = obj.Net_Amnt;
TBH.Katt_Amnt = obj.Katt_Amnt;
TBH.Date_Modifided = Convert.ToDateTime(DateTime.Now);
db.SaveChanges();
chlnBoookId = TBH.DelvChln_Idno;
//List<tblDelvChlnDetl> ChlnDetl = db.tblDelvChlnDetls.Where(rd => rd.DelvChlnHead_Idno == ChlnIdno).ToList();
//foreach (tblDelvChlnDetl rgd in ChlnDetl)
//{
// db.tblDelvChlnDetls.DeleteObject(rgd);
// db.SaveChanges();
//}
//if (Dttemp.Rows.Count > 0)
//{
// foreach (DataRow Dr in Dttemp.Rows)
// {
// tblChlnBookDetl objtblChlnBookDetl = new tblChlnBookDetl();
// objtblChlnBookDetl.GR_Idno = Convert.ToInt32(Dr["Gr_Idno"]);
// objtblChlnBookDetl.DelvryPlce_Idno = DelvPlcIdno;
// objtblChlnBookDetl.ChlnBookHead_Idno = chlnBoookId;
// db.tblChlnBookDetls.AddObject(objtblChlnBookDetl);
// db.SaveChanges();
// }
// // dbTran.Commit();
//}
//if (Dttemp.Rows.Count > 0)
//{
// foreach (DataRow Dr in Dttemp.Rows)
// {
// Int32 GrIdno = 0;
// GrIdno = Convert.ToInt32(Dr["Gr_Idno"]); ;
// TblGrHead objTblGrHead = (from obj1 in db.TblGrHeads where obj1.GR_Idno == GrIdno select obj1).FirstOrDefault();
// objTblGrHead.Chln_Idno = chlnBoookId;
// db.SaveChanges();
// }
//}
}
}
}
catch
{
}
}
return(chlnBoookId);
}
