public int DeleteStcktransfer(Int64 HeadId, Int64 UserIdno, string con)
{
int value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblStckTrans_Head qth = db.tblStckTrans_Head.Where(h => h.StckTrans_Idno == HeadId).FirstOrDefault();
List <tblStckTrans_Detl> qtd = db.tblStckTrans_Detl.Where(d => d.StckTrans_Idno == HeadId).ToList();
if (qth != null)
{
foreach (var d in qtd)
{
db.tblStckTrans_Detl.DeleteObject(d);
db.SaveChanges();
if (d.ItemType_Idno == 1)
{
Stckdetl objStckDetl = (from obj1 in db.Stckdetls where obj1.SerlDetl_id == d.SerialNo_Idno select obj1).FirstOrDefault();
objStckDetl.Br_Trans = false;
db.SaveChanges();
}
}
db.tblStckTrans_Head.DeleteObject(qth);
db.SaveChanges();
value = 1;
}
}
return(value);
}
public Int64 Insert(tblStckTrans_Head StckHead, List <tblStckTrans_Detl> StransDetl)
{
Int64?HeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
tblStckTrans_Head TH = db.tblStckTrans_Head.Where(SH => SH.StckTrans_No == StckHead.StckTrans_No).FirstOrDefault();
if (TH != null)
{
HeadId = -1;
}
else
{
db.tblStckTrans_Head.AddObject(StckHead);
db.SaveChanges();
HeadId = StckHead.StckTrans_Idno;
if (StransDetl.Count > 0)
{
foreach (tblStckTrans_Detl std in StransDetl)
{
std.StckTrans_Idno = Convert.ToInt32(HeadId);
db.tblStckTrans_Detl.AddObject(std);
db.SaveChanges();
if (std.ItemType_Idno == 1)
{
Stckdetl objStckDetl = (from obj1 in db.Stckdetls where obj1.SerlDetl_id == std.SerialNo_Idno select obj1).FirstOrDefault();
objStckDetl.Br_Trans = true;
db.SaveChanges();
}
}
dbTran.Commit();
}
}
}
catch
{
dbTran.Rollback();
}
}
}
return(Convert.ToInt64(HeadId));
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
DtTemp = (DataTable)ViewState["dt"];
if (DtTemp == null || DtTemp.Rows.Count <= 0)
{
ShowMessage("Please enter details");
drpItemType.Focus();
return;
}
if (Convert.ToInt32(drpBaseCity.SelectedValue) == Convert.ToInt32(drpDeliveryPlace.SelectedValue))
{
//ShowMessage("Issuing Location and Receiving Location can't be same");
Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "Comparecity()", true);
drpDeliveryPlace.Focus(); return;
}
if (drpBaseCity.SelectedIndex == 0)
{
this.ShowMessage("Please select Issuing Location"); drpBaseCity.Focus(); return;
}
if (drpDeliveryPlace.SelectedIndex == 0)
{
this.ShowMessage("Please select Receiving Location"); drpDeliveryPlace.Focus(); return;
}
//StockTransferDAL objstck = new StockTransferDAL();
tblStckTrans_Head objtblStck = new tblStckTrans_Head();
objtblStck.StckTrans_No = Convert.ToInt32(txtIssueNo.Text.Trim());
objtblStck.StckTrans_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text.Trim()));
objtblStck.IssLoc_Idno = Convert.ToInt32(drpBaseCity.SelectedValue);
objtblStck.RecLoc_Idno = Convert.ToInt32(drpDeliveryPlace.SelectedValue);
objtblStck.Year_Idno = Convert.ToInt32(ddlDateRange.SelectedValue);
objtblStck.Remark = txtRemark.Text.Trim();
objtblStck.User_Idno = Convert.ToInt32(Session["UserIdno"]);
objtblStck.Net_Amnt = Convert.ToDouble(txtNetAmnt.Text.Trim());
objtblStck.Date_Created = DateTime.Now;
objtblStck.Date_Modified = DateTime.Now;
List <tblStckTrans_Detl> objstckTrDetl = new List <tblStckTrans_Detl>();
if (DtTemp != null)
{
foreach (DataRow dtrow in DtTemp.Rows)
{
tblStckTrans_Detl objDetl = new tblStckTrans_Detl();
objDetl.ItemType_Idno = Convert.ToInt64(dtrow["ITEM_TYPEID"]);
objDetl.SerialNo_Idno = Convert.ToInt64(Convert.ToString(dtrow["ITEM_SERIALID"]) == "" ? "0" : dtrow["ITEM_SERIALID"]);
objDetl.Item_Serial_No = Convert.ToString(dtrow["ITEM_SERIAL"]);
objDetl.TyreType_Idno = Convert.ToInt64(Convert.ToString(dtrow["TYRE_TYPEID"]) == "" ? "0" : dtrow["TYRE_TYPEID"]);
objDetl.Item_Idno = Convert.ToInt64(Convert.ToString(dtrow["ITEM_ID"]) == "" ? "0" : dtrow["ITEM_ID"]);
objDetl.Qty = Convert.ToDouble(dtrow["ITEM_QTY"]);
objDetl.Rate = Convert.ToDouble(dtrow["ITEM_RATE"]);
objDetl.Tot_Amnt = Convert.ToDouble(dtrow["ITEM_QTY"]) * Convert.ToDouble(dtrow["ITEM_RATE"]);
objstckTrDetl.Add(objDetl);
}
}
else
{
DtTemp = CreateDt();
}
if (objstckTrDetl.Count <= 0)
{
ShowMessage("Please enter details");
return;
}
Int64 InsertId = 0;
Int64 UpdateId = 0;
StockTransferDAL obj = new StockTransferDAL();
if (Convert.ToInt32(hidStckid.Value) > 0)
{
objtblStck.StckTrans_Idno = Convert.ToInt32(hidStckid.Value);
UpdateId = obj.Update(objtblStck, objstckTrDetl);
}
else
{
InsertId = obj.Insert(objtblStck, objstckTrDetl);
}
obj = null;
if (InsertId > 0)
{
strMsg = "Record save successfully";
}
else if (UpdateId > 0)
{
strMsg = "Record Update successfully";
}
else if (InsertId < 0)
{
strMsg = "Receipt No already exists";
}
else if (UpdateId < 0)
{
strMsg = "Record not Update successfully";
}
else
{
strMsg = "Record not saved successfully";
}
//ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
//
ShowMessage(strMsg);
this.ClearAll();
}
public Int64 Update(tblStckTrans_Head StckHead, List <tblStckTrans_Detl> StransDetl)
{
Int64 HeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
tblStckTrans_Head TH = db.tblStckTrans_Head.Where(SH => SH.StckTrans_No == StckHead.StckTrans_No && SH.StckTrans_Idno != StckHead.StckTrans_Idno).FirstOrDefault();
if (TH != null)
{
HeadId = -1;
}
else
{
tblStckTrans_Head Stk = db.tblStckTrans_Head.Where(sd => sd.StckTrans_Idno == StckHead.StckTrans_Idno).FirstOrDefault();
if (Stk != null)
{
//qtn.Chln_Idno = QtnHead.Chln_Idno;
Stk.Date_Modified = DateTime.Now;
Stk.StckTrans_Date = StckHead.StckTrans_Date;
Stk.IssLoc_Idno = StckHead.IssLoc_Idno;
Stk.RecLoc_Idno = StckHead.RecLoc_Idno;
Stk.User_Idno = StckHead.User_Idno;
Stk.Net_Amnt = StckHead.Net_Amnt;
Stk.Year_Idno = StckHead.Year_Idno;
Stk.Remark = StckHead.Remark;
db.SaveChanges();
HeadId = StckHead.StckTrans_Idno;
List <tblStckTrans_Detl> StkDel = db.tblStckTrans_Detl.Where(qnd => qnd.StckTrans_Idno == StckHead.StckTrans_Idno).ToList();
foreach (tblStckTrans_Detl qtd1 in StkDel)
{
db.tblStckTrans_Detl.DeleteObject(qtd1);
db.SaveChanges();
if (qtd1.ItemType_Idno == 1)
{
Stckdetl objStckDetl = (from obj1 in db.Stckdetls where obj1.SerlDetl_id == qtd1.SerialNo_Idno select obj1).FirstOrDefault();
objStckDetl.Br_Trans = false;
db.SaveChanges();
}
}
foreach (tblStckTrans_Detl std1 in StransDetl)
{
std1.StckTrans_Idno = Convert.ToInt32(HeadId);
db.tblStckTrans_Detl.AddObject(std1);
db.SaveChanges();
if (std1.ItemType_Idno == 1)
{
Stckdetl objStckDetl = (from obj1 in db.Stckdetls where obj1.SerlDetl_id == std1.SerialNo_Idno select obj1).FirstOrDefault();
objStckDetl.Br_Trans = true;
db.SaveChanges();
}
}
dbTran.Commit();
}
}
}
catch
{
dbTran.Rollback();
}
}
}
return(HeadId);
}
