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