public int Delete(Int64 HeadId) { //clsAccountPosting objclsAccountPosting = new clsAccountPosting(); int value = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { TyreIssHead qth = db.TyreIssHeads.Where(h => h.MatIss_Idno == HeadId).FirstOrDefault(); List <Stckdetl> ObjStckDetl = db.Stckdetls.Where(h => h.MtrlIssue_Idno == HeadId).ToList(); List <TyreIssDetl> qtd = db.TyreIssDetls.Where(d => d.MatIssHead_Idno == HeadId).ToList(); if (qth != null && ObjStckDetl != null) { foreach (var d in qtd) { db.TyreIssDetls.DeleteObject(d); db.SaveChanges(); } foreach (var b in ObjStckDetl) { b.MtrlIssue_Idno = 0; b.Is_Issued = false; db.SaveChanges(); } db.TyreIssHeads.DeleteObject(qth); db.SaveChanges(); value = 1; } } return(value); }
private void PrintMaterial(TyreIssHead MatHead, object Matdetl) { Repeater obj = new Repeater(); double dcmsn = 0, dblty = 0, dcrtge = 0, dsuchge = 0, dwges = 0, dPF = 0, dtax = 0, dtoll = 0, dqty = 0, damnt = 0, dweight = 0; string CompName = ""; string Add1 = "", Add2 = ""; string PhNo = ""; string City = ""; string State = ""; string PanNo; string TinNo = ""; string Serv_No = ""; string Through = ""; string FaxNo = ""; string Remark = ""; string DelNoteRef = ""; int iPrintOption, PrintRcptAmnt = 0; string strTermCond = ""; Int32 PriPrinted = 0; Int32 ReportTyp = 0; int compID = 0; string numbertoent = ""; DataSet CompDetl = SqlHelper.ExecuteDataset(ApplicationFunction.ConnectionString(), CommandType.Text, "select * from tblcompmast"); # region Company Details
public void Populate(Int32 intMatIdNo) { TyreIssueDAL obj = new TyreIssueDAL(); TyreIssHead objMatHead = obj.SelectMatHead(intMatIdNo); var objMatDetl = obj.SelectMatDetail(intMatIdNo); hidGRHeadIdno.Value = Convert.ToString(intMatIdNo); if (objMatHead != null) { ddlDateRange.SelectedValue = Convert.ToString(objMatHead.Year_Idno); txtGRDate.Text = string.IsNullOrEmpty(Convert.ToString(objMatHead.MatIss_Date)) ? "" : Convert.ToDateTime(objMatHead.MatIss_Date).ToString("dd-MM-yyyy"); iGrAgainst = Convert.ToInt32(objMatHead.MatIss_Typ); // RDbDirect.Enabled = false; RDbRecpt.Enabled = false; //new txtRemarkhead.Text = string.IsNullOrEmpty(Convert.ToString(objMatHead.ReMark)) ? "" : Convert.ToString(objMatHead.ReMark); txtGRNo.Text = string.IsNullOrEmpty(Convert.ToString(objMatHead.MatIss_No)) ? "" : Convert.ToString(objMatHead.MatIss_No); ddlTruckNo.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objMatHead.Truck_Idno)) ? "0" : Convert.ToString(objMatHead.Truck_Idno); ddlTruckNo_SelectedIndexChanged(null, null); ddlDriver.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objMatHead.Driver_Idno)) ? "0" : Convert.ToString(objMatHead.Driver_Idno); ddlReciver.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objMatHead.Driver_Idno)) ? "0" : Convert.ToString(objMatHead.Driver_Idno); ddlLocation.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objMatHead.Loc_Idno)) ? "0" : Convert.ToString(objMatHead.Loc_Idno); dtTemp = CreateDt(); for (int counter = 0; counter < objMatDetl.Count; counter++) { string strItemName = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Item_Name")); string strItemNameId = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Iteam_Idno")); string strQty = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Item_Qty")); string strWeight = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Item_Weght")); string strRate = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Item_Rate")); string strAmount = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Item_Amnt")); string strDetail = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "Remark")); string strStckdetlNO = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "SerialNo")); string strStckdetl_Idno = Convert.ToString(DataBinder.Eval(objMatDetl[counter], "SerlDetl_id")); ApplicationFunction.DatatableAddRow(dtTemp, counter + 1, strItemName, strItemNameId, strQty, strWeight, strRate, strAmount, strDetail, strStckdetlNO, strStckdetl_Idno); } ViewState["dt"] = dtTemp; BindGridT(); txtNetAmnt.Text = string.IsNullOrEmpty(Convert.ToString(objMatHead.Net_Amnt)) ? "0" : String.Format("{0:0,0.00}", objMatHead.Net_Amnt); PrintMaterial(objMatHead, objMatDetl); } obj = null; }
public Int64 MatUpdate(Int64 intGRIdno, DateTime?dtMat_Date, Int32 IAgainst, Int64 intMat_No, Int32 intLoc_Idno, Int32 TruckNoIdno, Double DNetAmnt, Int32 YearIdno, DataTable dtDetail, Int32 intIssueTo, string strRemark, Int64 DriverIdno) { Int64 intGrIdno = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { try { TyreIssHead objGRHead = db.TyreIssHeads.Where(rh => (rh.MatIss_Idno != intGRIdno) && (rh.MatIss_No == intMat_No) && (rh.Loc_Idno == intLoc_Idno) && (rh.Year_Idno == YearIdno)).FirstOrDefault(); if (objGRHead == null) { TyreIssHead objMatIssHead1 = db.TyreIssHeads.Where(rh => rh.MatIss_Idno == intGRIdno).FirstOrDefault(); if (objMatIssHead1 != null) { objMatIssHead1.MatIss_Date = dtMat_Date; objMatIssHead1.MatIss_Typ = IAgainst; objMatIssHead1.MatIss_No = intMat_No; objMatIssHead1.Loc_Idno = intLoc_Idno; objMatIssHead1.Truck_Idno = TruckNoIdno; objMatIssHead1.Net_Amnt = DNetAmnt; objMatIssHead1.Year_Idno = YearIdno; objMatIssHead1.Issue_To = intIssueTo; objMatIssHead1.ReMark = strRemark; objMatIssHead1.Date_Modified = System.DateTime.Now; objMatIssHead1.Mat_Frm = "BK"; objMatIssHead1.Driver_Idno = DriverIdno; db.SaveChanges(); intGrIdno = objMatIssHead1.MatIss_Idno; if (intGrIdno > 0) { List <TyreIssDetl> lstGrDetl = db.TyreIssDetls.Where(obj => obj.MatIssHead_Idno == intGrIdno).ToList(); if (lstGrDetl.Count > 0) { foreach (TyreIssDetl obj in lstGrDetl) { db.TyreIssDetls.DeleteObject(obj); } db.SaveChanges(); } List <Stckdetl> ObjStckDetl = db.Stckdetls.Where(h => h.MtrlIssue_Idno == intGrIdno).ToList(); if (ObjStckDetl != null) { foreach (var b in ObjStckDetl) { b.MtrlIssue_Idno = 0; b.Is_Issued = false; db.SaveChanges(); } } foreach (DataRow row in dtDetail.Rows) { Int64 StckDetlIdno = Convert.ToInt64(row["StckDetl_Idno"]); Stckdetl objStckDetl = db.Stckdetls.Where(r => r.SerlDetl_id == StckDetlIdno).SingleOrDefault(); objStckDetl.MtrlIssue_Idno = Convert.ToInt64(intGrIdno); objStckDetl.Is_Issued = true; TyreIssDetl objMatIssDetl = new TyreIssDetl(); objMatIssDetl.MatIssHead_Idno = Convert.ToInt64(intGrIdno); objMatIssDetl.Iteam_Idno = Convert.ToInt32(row["Item_Idno"]); objMatIssDetl.Item_Qty = Convert.ToInt64(row["Quantity"]); objMatIssDetl.Item_Weght = Convert.ToDouble(row["Weight"]); objMatIssDetl.Item_Rate = Convert.ToDouble(row["Rate"]); objMatIssDetl.Item_Amnt = Convert.ToDouble(row["Amount"]); objMatIssDetl.Remark = Convert.ToString(row["Detail"]); objMatIssDetl.StckDetl_Idno = Convert.ToInt64(row["StckDetl_Idno"]); db.TyreIssDetls.AddObject(objMatIssDetl); db.SaveChanges(); } } } } else { intGrIdno = -1; } } catch (Exception Ex) { intGrIdno = 0; } } return(intGrIdno); }
public Int64 InsertMat(DateTime?dtMat_Date, Int32 IAgainst, Int64 intMat_No, Int32 intLoc_Idno, Int32 TruckNoIdno, Double DNetAmnt, Int32 YearIdno, DataTable dtDetail, Int32 intIssueTo, string strRemark, Int64 DriverIdno) { Int64 intMateIdno = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { try { TyreIssHead objMatHead = db.TyreIssHeads.Where(rh => (rh.MatIss_No == intMat_No) && (rh.Loc_Idno == intLoc_Idno) && (rh.Year_Idno == YearIdno)).FirstOrDefault(); if (objMatHead == null) { objMatHead = new TyreIssHead(); objMatHead.MatIss_Date = dtMat_Date; objMatHead.MatIss_Typ = IAgainst; objMatHead.MatIss_No = intMat_No; objMatHead.Loc_Idno = intLoc_Idno; objMatHead.Truck_Idno = TruckNoIdno; objMatHead.Net_Amnt = DNetAmnt; objMatHead.Year_Idno = YearIdno; objMatHead.Issue_To = intIssueTo; objMatHead.ReMark = strRemark; objMatHead.Date_Added = System.DateTime.Now; objMatHead.Mat_Frm = "BK"; objMatHead.Driver_Idno = DriverIdno; db.TyreIssHeads.AddObject(objMatHead); db.SaveChanges(); intMateIdno = objMatHead.MatIss_Idno; if (intMateIdno > 0) { foreach (DataRow row in dtDetail.Rows) { Int64 StckDetlIdno = Convert.ToInt64(row["StckDetl_Idno"]); Stckdetl objStckDetl = db.Stckdetls.Where(r => r.SerlDetl_id == StckDetlIdno).SingleOrDefault(); objStckDetl.MtrlIssue_Idno = Convert.ToInt64(intMateIdno); objStckDetl.Is_Issued = true; TyreIssDetl objMatDetl = new TyreIssDetl(); objMatDetl.MatIssHead_Idno = Convert.ToInt64(intMateIdno); objMatDetl.Iteam_Idno = Convert.ToInt32(row["Item_Idno"]); objMatDetl.Item_Qty = Convert.ToInt64(row["Quantity"]); objMatDetl.Item_Weght = Convert.ToDouble(row["Weight"]); objMatDetl.Item_Rate = Convert.ToDouble(row["Rate"]); objMatDetl.Item_Amnt = Convert.ToDouble(row["Amount"]); objMatDetl.Remark = Convert.ToString(row["Detail"]); objMatDetl.StckDetl_Idno = Convert.ToInt64(row["StckDetl_Idno"]); db.TyreIssDetls.AddObject(objMatDetl); db.SaveChanges(); } // tScope.Complete(); } } else { intMateIdno = -1; } } catch (Exception Ex) { intMateIdno = 0; } } return(intMateIdno); }