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