public Int64 Insert(tblSummaryRegister obj)
{
Int64 AmntHeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblSummaryRegister AmtHead = new tblSummaryRegister();
db.Connection.Open();
try
{
tblSummaryRegister RH = db.tblSummaryRegisters.Where(rh => rh.SumReg_No == obj.SumReg_No && rh.FromCity_Idno == obj.FromCity_Idno && rh.Year_Idno == obj.Year_Idno).FirstOrDefault();
if (RH != null)
{
AmntHeadId = -1;
}
else
{
db.tblSummaryRegisters.AddObject(obj);
db.SaveChanges();
AmntHeadId = obj.SumReg_Idno;
}
}
catch
{
}
return(AmntHeadId);
}
}
public Int64 Update(tblSummaryRegister obj, Int32 Head_Idno)
{
Int64 AmntHeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
// using (DbTransaction dbTran = db.Connection.BeginTransaction())
// {
try
{
tblSummaryRegister CH = db.tblSummaryRegisters.Where(rh => rh.SumReg_No == obj.SumReg_No && rh.SumReg_Idno != Head_Idno && rh.FromCity_Idno == obj.FromCity_Idno && rh.Year_Idno == obj.Year_Idno).FirstOrDefault();
if (CH != null)
{
AmntHeadId = -1;
}
else
{
tblSummaryRegister TBH = db.tblSummaryRegisters.Where(rh => rh.SumReg_Idno == Head_Idno).FirstOrDefault();
if (TBH != null)
{
TBH.SumReg_No = obj.SumReg_No;
TBH.FromCity_Idno = obj.FromCity_Idno;
TBH.SumReg_Date = obj.SumReg_Date;
TBH.Year_Idno = obj.Year_Idno;
TBH.Chln_Idno = obj.Chln_Idno;
TBH.Crossing_Amnt = obj.Crossing_Amnt;
TBH.Delivery_Amnt = obj.Delivery_Amnt;
TBH.Driver_idno = obj.Driver_idno;
TBH.Freight_Amnt = obj.Freight_Amnt;
TBH.Katt_Amnt = obj.Katt_Amnt;
TBH.Labour_Amnt = obj.Labour_Amnt;
TBH.Net_Amnt = obj.Net_Amnt;
TBH.Date_Modified = obj.Date_Modified;
TBH.Octrai_Amnt = obj.Octrai_Amnt;
TBH.Other_Charges = obj.Other_Charges;
TBH.Total_Amnt1 = obj.Total_Amnt1;
TBH.Total_Amnt2 = obj.Total_Amnt2;
TBH.Truck_Idno = obj.Truck_Idno;
TBH.Way_Amnt = obj.Way_Amnt;
TBH.Date_Modified = DateTime.Now;
db.SaveChanges();
AmntHeadId = obj.SumReg_Idno;
AmntHeadId = TBH.SumReg_Idno;
}
}
}
catch
{
}
}
return(AmntHeadId);
}
public int Delete(Int64 HeadId)
{
int value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblSummaryRegister qth = db.tblSummaryRegisters.Where(h => h.SumReg_Idno == HeadId).FirstOrDefault();
if (qth != null)
{
db.tblSummaryRegisters.DeleteObject(qth);
db.SaveChanges();
value = 1;
}
}
return(value);
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
string strMsg = string.Empty;
SummaryRegisterDAL objItemMast = new SummaryRegisterDAL();
Int64 intItemIdno = 0;
tblSummaryRegister obj = new tblSummaryRegister();
obj.Year_Idno = Convert.ToInt32(ddldateRange.SelectedValue);
obj.SumReg_No = Convert.ToInt64(Convert.ToString(txtRcptNo.Text.Trim()) == "" ? 0 : Convert.ToInt64(txtRcptNo.Text.Trim()));
obj.SumReg_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtGRDate.Text.Trim().ToString()));
obj.Date_Added = DateTime.Now;
obj.Date_Modified = null;
obj.FromCity_Idno = Convert.ToInt64(Convert.ToString(ddlFromCity.SelectedValue) == "" ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue));
obj.Chln_Idno = Convert.ToInt64(Convert.ToString(hidchlnIdno.Value) == "" ? 0 : Convert.ToInt64(hidchlnIdno.Value));
obj.Chln_no = Convert.ToInt64(Convert.ToString(txtchlnNo.Text.Trim()) == "" ? 0 : Convert.ToInt64(txtchlnNo.Text.Trim()));
obj.Truck_Idno = Convert.ToInt64(Convert.ToString(ddltruckno.SelectedValue) == "" ? 0 : Convert.ToInt64(ddltruckno.SelectedValue));
obj.Driver_idno = Convert.ToInt64(Convert.ToString(ddldriver.SelectedValue) == "" ? 0 : Convert.ToInt64(ddldriver.SelectedValue));
obj.Crossing_Amnt = string.IsNullOrEmpty((Convert.ToString(txtCrossing.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txtCrossing.Text)).Replace(",", ""));
obj.Way_Amnt = string.IsNullOrEmpty((Convert.ToString(txtWAy.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txtWAy.Text)).Replace(",", ""));
obj.Other_Charges = string.IsNullOrEmpty((Convert.ToString(txtotherCharg.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txtotherCharg.Text)).Replace(",", ""));
obj.Freight_Amnt = string.IsNullOrEmpty((Convert.ToString(txtfreightCharg.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txtfreightCharg.Text)).Replace(",", ""));
obj.Total_Amnt1 = string.IsNullOrEmpty((Convert.ToString(txttotal1.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txttotal1.Text)).Replace(",", ""));
obj.Katt_Amnt = string.IsNullOrEmpty((Convert.ToString(txtKatt.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txtKatt.Text)).Replace(",", ""));
obj.Labour_Amnt = string.IsNullOrEmpty((Convert.ToString(txtlabour.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txtlabour.Text)).Replace(",", ""));
obj.Delivery_Amnt = string.IsNullOrEmpty((Convert.ToString(txtDelivery.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txtDelivery.Text)).Replace(",", ""));
obj.Octrai_Amnt = string.IsNullOrEmpty((Convert.ToString(txtOctrai.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txtOctrai.Text)).Replace(",", ""));
obj.Total_Amnt2 = string.IsNullOrEmpty((Convert.ToString(txttotal2.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txttotal2.Text)).Replace(",", ""));
obj.Net_Amnt = string.IsNullOrEmpty((Convert.ToString(txtNetTotal.Text)).Replace(",", "")) ? 0 : Convert.ToDouble((Convert.ToString(txtNetTotal.Text)).Replace(",", ""));
if (string.IsNullOrEmpty(hidSummryRegidno.Value) == true)
{
intItemIdno = objItemMast.Insert(obj);
}
else
{
lnkbtnNew.Visible = false; lnkbtnPrintClick.Visible = false;
intItemIdno = objItemMast.Update(obj, Convert.ToInt32(Convert.ToString(hidSummryRegidno.Value) == "" ? 0 : Convert.ToInt32(hidSummryRegidno.Value)));
}
objItemMast = null;
if (intItemIdno > 0)
{
if (string.IsNullOrEmpty(hidSummryRegidno.Value) == false)
{
strMsg = "Record updated successfully.";
}
else
{
strMsg = "Record saved successfully.";
}
this.ClearControls();
}
else if (intItemIdno < 0)
{
strMsg = "Record already exists.";
}
else
{
if (string.IsNullOrEmpty(hidSummryRegidno.Value) == false)
{
strMsg = "Record not updated.";
}
else
{
strMsg = "Record not saved.";
}
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true);
// txtItemName.Focus();
}
