public Int64 Update(tblClaimHead obj, Int32 Head_Idno, DataTable Dttemp) { Int64 ClaimHeadIdno = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { db.Connection.Open(); using (DbTransaction dbTran = db.Connection.BeginTransaction()) { try { tblClaimHead CH = db.tblClaimHeads.Where(ch => ch.Claim_No == obj.Claim_No && ch.ClaimHead_Idno != Head_Idno && ch.FromLoc_Idno == obj.FromLoc_Idno && ch.Year_Idno == obj.Year_Idno).FirstOrDefault(); if (CH != null) { ClaimHeadIdno = -1; } else { tblClaimHead CHead = db.tblClaimHeads.Where(ch => ch.ClaimHead_Idno == Head_Idno).FirstOrDefault(); if (CHead != null) { db.SaveChanges(); ClaimHeadIdno = CHead.ClaimHead_Idno; List <tblClaimDetl> ClaimDetl = db.tblClaimDetls.Where(cd => cd.ClaimHead_Idno == Head_Idno).ToList(); foreach (tblClaimDetl tcd in ClaimDetl) { db.tblClaimDetls.DeleteObject(tcd); db.SaveChanges(); } if (Dttemp != null && Dttemp.Rows.Count > 0) { foreach (DataRow Dr in Dttemp.Rows) { tblClaimDetl objtblClaimDetl = new tblClaimDetl(); objtblClaimDetl.ClaimHead_Idno = ClaimHeadIdno; objtblClaimDetl.StckDetl_Idno = Convert.ToInt64(Dr["SerialIdno"]); objtblClaimDetl.SBillHead_Idno = Convert.ToInt64(Dr["SbillIdno"]); objtblClaimDetl.Defect_Remark = Convert.ToString(Dr["DefectRemark"]); objtblClaimDetl.VechApp_Details = Convert.ToString(Dr["VechAppDetails"]); db.tblClaimDetls.AddObject(objtblClaimDetl); db.SaveChanges(); } } dbTran.Commit(); } } } catch { dbTran.Rollback(); } } } return(ClaimHeadIdno); }
private void Populate(Int64 ClaimHeadIdno) { ClaimFrmDAL objClaimFrmDAL = new ClaimFrmDAL(); tblClaimHead ObjHead = objClaimFrmDAL.Select_ClaimHead(ClaimHeadIdno); if (ObjHead != null) { ViewState["ClaimHeadIdno"] = ClaimHeadIdno; ddlDateRange.SelectedValue = Convert.ToString(ObjHead.Year_Idno); txtPrefixNo.Text = ObjHead.Prefix_No.ToString(); txtClaimDate.Text = string.IsNullOrEmpty(ObjHead.ClaimHead_Date.ToString()) ? "" : Convert.ToDateTime(ObjHead.ClaimHead_Date).ToString("dd-MM-yyyy"); if ((string.IsNullOrEmpty(Convert.ToString(ObjHead.Claim_Against)) ? 0 : Convert.ToInt64(ObjHead.Claim_Against)) > 0) { RDbParty.Checked = true; } else { RDbSaleBill.Checked = true; } txtClaimNo.Text = string.IsNullOrEmpty(ObjHead.Claim_No.ToString()) ? "" : Convert.ToString(ObjHead.Claim_No); ddlFromCity.SelectedValue = string.IsNullOrEmpty(ObjHead.FromLoc_Idno.ToString())? "0" : Convert.ToString(ObjHead.FromLoc_Idno); ddlParty.SelectedValue = string.IsNullOrEmpty(ObjHead.Prty_Idno.ToString()) ? "0" : Convert.ToString(ObjHead.Prty_Idno); ddlCompanyName.SelectedValue = string.IsNullOrEmpty(ObjHead.Comp_Idno.ToString()) ? "0" : Convert.ToString(ObjHead.Comp_Idno); RDbParty.Enabled = false; RDbSaleBill.Enabled = false; ddlFromCity.Enabled = false; imgSearch.Visible = false; dtTemp = CreateDt(); string Result = String.Empty; var ClaimNo = objClaimFrmDAL.SelectSaleBillNo(Convert.ToInt64(ClaimHeadIdno)); if (ClaimNo != null && ClaimNo > 0) { lblSbillNo.Text = "Sale Bill No : " + ClaimNo.ToString(); } DataTable dt = new DataTable(); if ((string.IsNullOrEmpty(Convert.ToString(ObjHead.Claim_Against)) ? 0 : Convert.ToInt64(ObjHead.Claim_Against)) > 0) { dt = objClaimFrmDAL.SelectClaimParty(ApplicationFunction.ConnectionString(), ClaimHeadIdno); } else { dt = objClaimFrmDAL.SelectClaimDetails(ApplicationFunction.ConnectionString(), ClaimHeadIdno); } if (dt != null && dt.Rows.Count > 0) { objClaimFrmDAL = null; ViewState["dt"] = dt; } this.BindGridT(); ViewState["dt"] = dtTemp; this.BindGridT(); } }
public int Delete(Int64 HeadId) { int value = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblClaimHead qth = db.tblClaimHeads.Where(h => h.ClaimHead_Idno == HeadId).FirstOrDefault(); List <tblClaimDetl> qtd = db.tblClaimDetls.Where(d => d.ClaimHead_Idno == HeadId).ToList(); if (qth != null) { foreach (var d in qtd) { db.tblClaimDetls.DeleteObject(d); db.SaveChanges(); } db.tblClaimHeads.DeleteObject(qth); db.SaveChanges(); value = 1; } } return(value); }
protected void lnkbtnSave_Click(object sender, EventArgs e) { string msg = ""; DateTime?ClaimDate = null; ClaimDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text)); ClaimFrmDAL objClaimFrmDAL = new ClaimFrmDAL(); DateTime CurrentDate = System.DateTime.Now; Int64 intAgainst = 0; if (RDbSaleBill.Checked == true) { intAgainst = 0; } else { intAgainst = 1; } if (grdMain.Rows.Count > 0) { DTMain = CreateDt(); foreach (GridViewRow row in grdMain.Rows) { HiddenField hidSerialIdno = (HiddenField)row.FindControl("hidSerialIdno"); HiddenField hidSbillIdno = (HiddenField)row.FindControl("hidSbillIdno"); TextBox txtDefRemark = (TextBox)row.FindControl("txtDefRemark"); TextBox txtVchAppDetl = (TextBox)row.FindControl("txtVchAppDetl"); ApplicationFunction.DatatableAddRow(DTMain, row.RowIndex + 1, hidSerialIdno.Value, hidSbillIdno.Value, txtDefRemark.Text, txtVchAppDetl.Text); } tblClaimHead objClaimHead = new tblClaimHead(); if (txtClaimDate.Text == "") { objClaimHead.ClaimHead_Date = null; } else { objClaimHead.ClaimHead_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text)); } objClaimHead.Claim_No = string.IsNullOrEmpty(Convert.ToString(txtClaimNo.Text.Trim())) ? 0 : Convert.ToInt64(txtClaimNo.Text.Trim()); objClaimHead.Prefix_No = string.IsNullOrEmpty(Convert.ToString(txtPrefixNo.Text.Trim())) ? "" : Convert.ToString(txtPrefixNo.Text.Trim()); objClaimHead.FromLoc_Idno = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue); objClaimHead.Year_Idno = string.IsNullOrEmpty(Convert.ToString(ddlDateRange.SelectedValue)) ? 0 : Convert.ToInt64(ddlDateRange.SelectedValue); objClaimHead.Prty_Idno = string.IsNullOrEmpty(Convert.ToString(ddlParty.SelectedValue)) ? 0 : Convert.ToInt64(ddlParty.SelectedValue); objClaimHead.Claim_Against = intAgainst; objClaimHead.Comp_Idno = string.IsNullOrEmpty(Convert.ToString(ddlCompanyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlCompanyName.SelectedValue); Int64 value = 0; using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required)) { if (ViewState["ClaimHeadIdno"] != null) { objClaimHead.Date_Modified = System.DateTime.Now; lnkbtnNew.Visible = false; value = objClaimFrmDAL.Update(objClaimHead, Convert.ToInt32(ViewState["ClaimHeadIdno"].ToString()), DTMain); objClaimFrmDAL = null; } else { objClaimHead.Date_Added = System.DateTime.Now; value = objClaimFrmDAL.Insert(objClaimHead, DTMain); objClaimFrmDAL = null; } if (ViewState["ClaimHeadIdno"] != null) { if (value > 0 && (ViewState["ClaimHeadIdno"] != null)) { ShowMessage("Record Update successfully"); Clear(); tScope.Complete(); } else if (value == -1) { ShowMessageErr("Claim Number Already Exist"); tScope.Dispose(); } else { ShowMessageErr("Record Not Update"); tScope.Dispose(); } } else { if (value > 0 && (ViewState["ClaimHeadIdno"] == null)) { ShowMessage("Record saved Successfully "); Clear(); tScope.Complete(); } else if (value == -1) { ShowMessageErr("Claim Number Already Exist"); tScope.Dispose(); } else { ShowMessageErr("Record Not saved Successfully "); tScope.Dispose(); } } } } else { ShowMessageErr("Please Search and Select Serial Number."); return; } }