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