public int Delete(Int64 HeadId) { int value = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblClaimToComHead qth = db.tblClaimToComHeads.Where(h => h.ClaimToComHead_Idno == HeadId).FirstOrDefault(); List <tblClaimToComDetl> qtd = db.tblClaimToComDetls.Where(d => d.ClaimToComHead_Idno == HeadId).ToList(); if (qth != null) { foreach (var d in qtd) { db.tblClaimToComDetls.DeleteObject(d); Stckdetl SD = db.Stckdetls.Where(B => B.SerlDetl_id == d.StckDetl_Idno).FirstOrDefault(); SD.Claim_Status = 1; db.SaveChanges(); } db.tblClaimToComHeads.DeleteObject(qth); db.SaveChanges(); value = 1; } } return(value); }
private void Populate(Int64 ClaimHeadIdno) { objClaimFrmDAL = new ClaimToDAL(); tblClaimToComHead ObjHead = objClaimFrmDAL.Select_ClaimHead(ClaimHeadIdno); if (ObjHead != null) { //SpanLastPrint.Visible = false; ViewState["ClaimHeadIdno"] = ClaimHeadIdno; hidid.Value = ClaimHeadIdno.ToString(); ddlDateRange.SelectedValue = Convert.ToString(ObjHead.Year_Idno); txtPrefixNo.Text = ObjHead.Prefix_No.ToString(); txtClaimDate.Text = string.IsNullOrEmpty(ObjHead.ClaimToComHead_Date.ToString()) ? "" : Convert.ToDateTime(ObjHead.ClaimToComHead_Date).ToString("dd-MM-yyyy"); txtClaimNo.Text = string.IsNullOrEmpty(ObjHead.ClaimToCom_No.ToString()) ? "" : Convert.ToString(ObjHead.ClaimToCom_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); if (ObjHead.Against == 2) { rdoAgnSend.Checked = false; rdoAgnReceived.Checked = true; } else { rdoAgnSend.Checked = true; rdoAgnReceived.Checked = false; } ddlCompanyName.SelectedValue = string.IsNullOrEmpty(ObjHead.Comp_Idno.ToString()) ? "0" : Convert.ToString(ObjHead.Comp_Idno); dtTemp = CreateDt(); string Result = String.Empty; if ((string.IsNullOrEmpty(Convert.ToString(Request.QueryString["ClaimHeadIdno"].ToString())) ? 0 : Convert.ToInt64(Request.QueryString["ClaimHeadIdno"].ToString())) > 0) { ddlFromCity.Enabled = false; imgSearch.Visible = false; } else { ddlFromCity.Enabled = true; imgSearch.Visible = true; } var Lst = objClaimFrmDAL.SelectClaimDetails(ClaimHeadIdno); if (Lst != null && Lst.Count > 0) { grdMain.DataSource = Lst; grdMain.DataBind(); if (rdoAgnReceived.Checked) { grdMain.Columns[9].Visible = grdMain.Columns[10].Visible = true; grdMain.Columns[4].Visible = grdMain.Columns[5].Visible = grdMain.Columns[6].Visible = grdMain.Columns[7].Visible = false; } else { grdMain.Columns[4].Visible = grdMain.Columns[5].Visible = grdMain.Columns[6].Visible = grdMain.Columns[7].Visible = true; grdMain.Columns[9].Visible = grdMain.Columns[10].Visible = false; } } } }
public Int64 UpdateForRecvd(tblClaimToComHead obj, Int32 Head_Idno, DataTable Dttemp) { Int64 ClaimHeadIdno = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { db.Connection.Open(); try { tblClaimToComHead CHead = db.tblClaimToComHeads.Where(ch => ch.ClaimToComHead_Idno == Head_Idno).FirstOrDefault(); if (CHead != null) { CHead.ClaimToComRec_Date = obj.ClaimToComRec_Date; CHead.Against = obj.Against; db.SaveChanges(); ClaimHeadIdno = CHead.ClaimToComHead_Idno; List <tblClaimToComDetl> ClaimDetl = db.tblClaimToComDetls.Where(cd => cd.ClaimToComHead_Idno == Head_Idno).ToList(); foreach (tblClaimToComDetl tcd in ClaimDetl) { for (int i = 0; i < Dttemp.Rows.Count; i++) { Int64 Value = Convert.ToInt64(Dttemp.Rows[i]["ClaimDetailsIdno"]); List <tblClaimToComDetl> ClaimDetls = db.tblClaimToComDetls.Where(cd => cd.ClaimToComDetl_Idno == Value).ToList(); foreach (tblClaimToComDetl tcds in ClaimDetls) { tcds.Status = Convert.ToInt64(Dttemp.Rows[i]["Status"]); tcds.New_SerialNo = Convert.ToString(Dttemp.Rows[i]["NewSerialNo"]); tcds.Remark = Convert.ToString(Dttemp.Rows[i]["Remark"]); db.SaveChanges(); string NewSerialNo = Dttemp.Rows[i]["NewSerialNo"].ToString(); if (string.IsNullOrEmpty(NewSerialNo) == false) { Stckdetl SD = db.Stckdetls.Where(d => d.SerialNo == NewSerialNo).FirstOrDefault(); tcds.NewStckDetl_Idno = SD.SerlDetl_id; db.SaveChanges(); } } } } } } catch { ClaimHeadIdno = 0; } } return(ClaimHeadIdno); }
public Int64 Insert(tblClaimToComHead obj, DataTable Dttemp) { Int64 ClaimToComHeadIdno = 0; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { tblClaimToComHead Claimhead = new tblClaimToComHead(); try { tblClaimToComHead CH = db.tblClaimToComHeads.Where(ch => ch.ClaimToCom_No == obj.ClaimToCom_No && ch.Prefix_No == obj.Prefix_No && ch.FromLoc_Idno == obj.FromLoc_Idno && ch.Year_Idno == obj.Year_Idno).FirstOrDefault(); if (CH != null) { ClaimToComHeadIdno = -1; } else { db.tblClaimToComHeads.AddObject(obj); db.SaveChanges(); ClaimToComHeadIdno = obj.ClaimToComHead_Idno; if (Dttemp != null && Dttemp.Rows.Count > 0) { foreach (DataRow Dr in Dttemp.Rows) { tblClaimToComDetl objtblClaimDetl = new tblClaimToComDetl(); objtblClaimDetl.ClaimToComHead_Idno = ClaimToComHeadIdno; objtblClaimDetl.StckDetl_Idno = Convert.ToInt64(Dr["SerialIdno"]); objtblClaimDetl.ClaimToHead_Idno = Convert.ToInt64(Dr["ClaimIdno"]); objtblClaimDetl.Defect_Remark = Convert.ToString(Dr["DefectRemark"]); objtblClaimDetl.VechApp_Details = Convert.ToString(Dr["VechAppDetails"]); objtblClaimDetl.Status = Convert.ToInt64(Dr["Status"]); objtblClaimDetl.Remark = Convert.ToString(Dr["Remark"]); objtblClaimDetl.New_SerialNo = Convert.ToString(Dr["NewSerialNo"]); db.tblClaimToComDetls.AddObject(objtblClaimDetl); Stckdetl SD = db.Stckdetls.Where(d => d.SerlDetl_id == objtblClaimDetl.StckDetl_Idno).FirstOrDefault(); SD.Claim_Status = 1; db.SaveChanges(); } } } } catch { ClaimToComHeadIdno = 0; } return(ClaimToComHeadIdno); } }
protected void lnkbtnSave_Click(object sender, EventArgs e) { string msg = ""; DateTime?ClaimDate = null; ClaimDate = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text)); objClaimFrmDAL = new ClaimToDAL(); DateTime CurrentDate = System.DateTime.Now; if (grdMain.Rows.Count > 0) { DTMain = CreateDt(); if (rdoAgnReceived.Checked) { foreach (GridViewRow row in grdMain.Rows) { Label lblGridSerialNo = (Label)row.FindControl("lblGridSerialNo"); TextBox txtNewSerialNo = (TextBox)row.FindControl("txtNewSerialNo"); DropDownList ddlStatus = (DropDownList)row.FindControl("ddlStatus"); if (txtNewSerialNo.Text.Trim() == "") { ShowMessageErr("Please Fill Serial Number."); txtNewSerialNo.Focus(); return; } if (lblGridSerialNo.Text.Trim() == txtNewSerialNo.Text.Trim()) { ShowMessageErr("New Serial Not same as old Serial,Check New Serial No." + txtNewSerialNo.Text.Trim() + ""); txtNewSerialNo.Focus(); return; } if (ddlStatus.SelectedValue == "1") { ShowMessageErr("Please Check Status should not be submitted."); ddlStatus.Focus(); return; } BindDropdownDAL obj = new BindDropdownDAL(); if (Request.QueryString["ClaimHeadIdno"] == null) { if (txtNewSerialNo.Text.Trim() != "") { Int64 Count = obj.CheckSerialNo(txtNewSerialNo.Text.Trim()); if (Count != 0) { ShowMessageErr("Serial Number :" + txtNewSerialNo.Text.Trim() + " already exists in stock."); txtNewSerialNo.Focus(); return; } } } } } foreach (GridViewRow row in grdMain.Rows) { HiddenField hidSerialIdno = (HiddenField)row.FindControl("hidSerialIdno"); HiddenField hidClaimIdno = (HiddenField)row.FindControl("hidClaimIdno"); Label txtDefRemark = (Label)row.FindControl("lblGridDefectNo"); Label txtVchAppDetl = (Label)row.FindControl("lblGridVehDetlNo"); DropDownList ddlStatus = (DropDownList)row.FindControl("ddlStatus"); TextBox txtRemarks = (TextBox)row.FindControl("txtRemarks"); TextBox txtNewSerialNo = (TextBox)row.FindControl("txtNewSerialNo"); HiddenField HidClaimDetailsIdno = (HiddenField)row.FindControl("HidClaimDetailsIdno"); ApplicationFunction.DatatableAddRow(DTMain, row.RowIndex + 1, hidSerialIdno.Value, hidClaimIdno.Value, txtDefRemark.Text.Trim(), txtVchAppDetl.Text.Trim(), ddlStatus.SelectedValue, txtRemarks.Text.Trim(), txtNewSerialNo.Text.Trim(), HidClaimDetailsIdno.Value); } if (rdoAgnReceived.Checked) { foreach (GridViewRow rows in grdMain.Rows) { TextBox txtNewSerialNo1 = (TextBox)rows.FindControl("txtNewSerialNo"); DataRow[] drs = DTMain.Select("NewSerialNo='" + txtNewSerialNo1.Text.Trim() + "'"); if (drs.Length > 1) { ShowMessageErr("Serial Number :" + txtNewSerialNo1.Text.Trim() + " already exists in list."); txtNewSerialNo1.Focus(); return; } } } tblClaimToComHead objClaimHead = new tblClaimToComHead(); if (rdoAgnReceived.Checked) { if (txtClaimDate.Text == "") { objClaimHead.ClaimToComRec_Date = null; } else { objClaimHead.ClaimToComRec_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text)); } } else { if (txtClaimDate.Text == "") { objClaimHead.ClaimToComHead_Date = null; } else { objClaimHead.ClaimToComHead_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtClaimDate.Text)); } } objClaimHead.ClaimToCom_No = string.IsNullOrEmpty(Convert.ToString(txtClaimNo.Text.Trim())) ? 0 : Convert.ToInt64(txtClaimNo.Text.Trim()); objClaimHead.ClaimHead_Idno = string.IsNullOrEmpty(Convert.ToString(HidClaimHeadIdno.Value)) ? 0 : Convert.ToInt64(HidClaimHeadIdno.Value); 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.Comp_Idno = string.IsNullOrEmpty(Convert.ToString(ddlCompanyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlCompanyName.SelectedValue); Int64 Against = 0; if (rdoAgnSend.Checked) { Against = 1; } else { Against = 2; } objClaimHead.Against = Against; Int64 value = 0; using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required)) { if (string.IsNullOrEmpty(hidid.Value) == true) { objClaimHead.Date_Added = System.DateTime.Now; value = objClaimFrmDAL.Insert(objClaimHead, DTMain); objClaimFrmDAL = null; } else { objClaimHead.Date_Modified = System.DateTime.Now; lnkbtnNew.Visible = false; if (rdoAgnReceived.Checked) { value = objClaimFrmDAL.UpdateForRecvd(objClaimHead, Convert.ToInt32(hidid.Value), DTMain); } else { value = objClaimFrmDAL.Update(objClaimHead, Convert.ToInt32(hidid.Value), DTMain); } objClaimFrmDAL = null; } if (string.IsNullOrEmpty(hidid.Value) == false) { if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == false)) { 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 && (string.IsNullOrEmpty(hidid.Value) == true)) { 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; } }
public Int64 Update(tblClaimToComHead 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 { tblClaimToComHead CH = db.tblClaimToComHeads.Where(ch => ch.ClaimToCom_No == obj.ClaimToCom_No && ch.ClaimToComHead_Idno != Head_Idno && ch.Against == obj.Against && ch.FromLoc_Idno == obj.FromLoc_Idno && ch.Year_Idno == obj.Year_Idno).FirstOrDefault(); if (CH != null) { ClaimHeadIdno = -1; } else { tblClaimToComHead CHead = db.tblClaimToComHeads.Where(ch => ch.ClaimToComHead_Idno == Head_Idno).FirstOrDefault(); if (CHead != null) { db.SaveChanges(); ClaimHeadIdno = CHead.ClaimToComHead_Idno; List <tblClaimToComDetl> ClaimDetl = db.tblClaimToComDetls.Where(cd => cd.ClaimToHead_Idno == Head_Idno).ToList(); foreach (tblClaimToComDetl tcd in ClaimDetl) { db.tblClaimToComDetls.DeleteObject(tcd); Stckdetl SD = db.Stckdetls.Where(d => d.SerlDetl_id == tcd.StckDetl_Idno).FirstOrDefault(); SD.Claim_Status = 1; db.SaveChanges(); } if (Dttemp != null && Dttemp.Rows.Count > 0) { foreach (DataRow Dr in Dttemp.Rows) { tblClaimToComDetl objtblClaimDetl = new tblClaimToComDetl(); objtblClaimDetl.ClaimToComHead_Idno = ClaimHeadIdno; objtblClaimDetl.StckDetl_Idno = Convert.ToInt64(Dr["SerialIdno"]); objtblClaimDetl.ClaimToHead_Idno = Convert.ToInt64(Dr["ClaimIdno"]); objtblClaimDetl.Defect_Remark = Convert.ToString(Dr["DefectRemark"]); objtblClaimDetl.VechApp_Details = Convert.ToString(Dr["VechAppDetails"]); objtblClaimDetl.Status = Convert.ToInt64(Dr["Status"]); objtblClaimDetl.Remark = Convert.ToString(Dr["Remark"]); objtblClaimDetl.New_SerialNo = Convert.ToString(Dr["NewSerialNo"]); db.tblClaimToComDetls.AddObject(objtblClaimDetl); Stckdetl SD = db.Stckdetls.Where(d => d.SerlDetl_id == objtblClaimDetl.StckDetl_Idno).FirstOrDefault(); SD.Claim_Status = 1; db.SaveChanges(); } } dbTran.Commit(); } } } catch { dbTran.Rollback(); } } } return(ClaimHeadIdno); }