public Int64 Insert(tblPayToOwnAcc obj)
{
Int64 AmntHeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblPayToOwnAcc AmtHead = new tblPayToOwnAcc();
db.Connection.Open();
// using (DbTransaction dbTran = db.Connection.BeginTransaction())
// {
try
{
tblPayToOwnAcc RH = db.tblPayToOwnAccs.Where(rh => rh.Rcpt_No == obj.Rcpt_No && rh.BaseCity_Idno == obj.BaseCity_Idno && rh.Year_IdNo == obj.Year_IdNo).FirstOrDefault();
if (RH != null)
{
AmntHeadId = -1;
}
else
{
obj.Date_Added = DateTime.Now;
obj.Date_Modified = DateTime.Now;
db.tblPayToOwnAccs.AddObject(obj);
db.SaveChanges();
AmntHeadId = obj.Id;
}
}
catch
{
// dbTran.Rollback();
}
return(AmntHeadId);
}
}
public Int64 Update(tblPayToOwnAcc obj, Int32 Head_Idno)
{
Int64 AmntHeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
//db.Connection.Open();
//using (DbTransaction dbTran = db.Connection.BeginTransaction())
//{
try
{
tblPayToOwnAcc CH = db.tblPayToOwnAccs.Where(rh => rh.Rcpt_No == obj.Rcpt_No && rh.Id != Head_Idno && rh.BaseCity_Idno == obj.BaseCity_Idno && rh.Year_IdNo == obj.Year_IdNo).FirstOrDefault();
if (CH != null)
{
AmntHeadId = -1;
}
else
{
tblPayToOwnAcc TBH = (from mast in db.tblPayToOwnAccs
where mast.Id == Head_Idno
select mast).FirstOrDefault();
if (TBH != null)
{
TBH.Rcpt_No = obj.Rcpt_No;
TBH.Rcpt_date = obj.Rcpt_date;
TBH.Year_IdNo = obj.Year_IdNo;
TBH.RcptType_Idno = obj.RcptType_Idno;
TBH.Driver_IdNo = obj.Driver_IdNo;
TBH.Inst_No = obj.Inst_No;
TBH.Inst_Dt = obj.Inst_Dt;
TBH.Bank_Idno = obj.Bank_Idno;
TBH.Comp_Id = obj.Comp_Id;
TBH.Remark = obj.Remark;
TBH.Date_Modified = obj.Date_Modified;
TBH.Amnt = obj.Amnt;
TBH.UserIdno = obj.UserIdno;
TBH.BaseCity_Idno = obj.BaseCity_Idno;
TBH.Date_Modified = DateTime.Now;
db.SaveChanges();
AmntHeadId = TBH.Id;
//dbTran.Commit();
}
}
}
catch
{
//dbTran.Rollback();
}
// }
}
return(AmntHeadId);
}
private void Populate(Int64 HeadId)
{
PaymentToOwnDAL obj = new PaymentToOwnDAL();
tblPayToOwnAcc AmntGrhead = obj.selectHead(HeadId);
ddldateRange.SelectedValue = Convert.ToString(AmntGrhead.Year_IdNo);
ddldateRange_SelectedIndexChanged(null, null);
ddldateRange.Enabled = false;
txtRcptNo.Text = Convert.ToString(AmntGrhead.Rcpt_No);
txtRcptNo.Visible = true; ddlFromCity.SelectedValue = Convert.ToString(AmntGrhead.BaseCity_Idno); BindPartName();
txtDate.Text = Convert.ToDateTime(AmntGrhead.Rcpt_date).ToString("dd-MM-yyyy");
//ddlDriverName.SelectedValue = Convert.ToString(AmntGrhead.Party_IdNo);
ddlRcptTyp.SelectedValue = Convert.ToString(AmntGrhead.RcptType_Idno);
ddlRcptType_SelectedIndexChanged(null, null);
ddlChallan.SelectedValue = Convert.ToString(AmntGrhead.Chln_IdNo);
ddlChallan_SelectedIndexChanged(null, null);
ddlCustmerBank.SelectedValue = Convert.ToString(AmntGrhead.Bank_Idno);
txtInstNo.Text = Convert.ToString(AmntGrhead.Inst_No);
txtInstDate.Text = (Convert.ToString(AmntGrhead.Inst_Dt) == "") ? "" : Convert.ToDateTime(AmntGrhead.Inst_Dt).ToString("dd-MM-yyyy");
TxtRemark.Text = Convert.ToString(AmntGrhead.Remark);
txtAmount.Text = Convert.ToString(AmntGrhead.Amnt);
ViewState["dt"] = DtTemp;
//For Daulat Print
string strChlnIdno = string.Empty;
for (int j = 0; j <= DtTemp.Rows.Count - 1; j++)
{
strChlnIdno = strChlnIdno + DtTemp.Rows[j]["Chln_Idno"].ToString() + ",";
}
if (strChlnIdno != "")
{
strChlnIdno = strChlnIdno.Substring(0, strChlnIdno.Length - 1);
}
//Int64 ChlnIdno = obj.GetChlnIdno(HeadId);
if (Convert.ToString(hidPrintType.Value) != "")
{
if (Convert.ToInt32(hidPrintType.Value) == 2)
{
if (strChlnIdno != "")
{
PrintChlnDetails(strChlnIdno);
}
}
}
obj = null;
}
public int Delete(Int64 HeadId, Int64 UserIdno, string con)
{
int value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
clsAccountPosting objclsAccountPosting = new clsAccountPosting();
tblPayToOwnAcc CH = db.tblPayToOwnAccs.Where(h => h.Id == HeadId).FirstOrDefault();
if (CH != null)
{
db.tblPayToOwnAccs.DeleteObject(CH);
db.SaveChanges();
value = 1;
}
}
return(value);
}
public void UpdateIsPosting(Int64 PayID)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
tblPayToOwnAcc GH = (from G in db.tblPayToOwnAccs where G.Id == PayID select G).FirstOrDefault();
if (GH != null)
{
GH.IS_Post = true;
db.SaveChanges();
}
}
catch (Exception e)
{
}
}
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
DtTemp = CreateDt();
PaymentToOwnDAL obj = new PaymentToOwnDAL();
tblPayToOwnAcc objRGH = new tblPayToOwnAcc();
objRGH.Rcpt_No = Convert.ToInt64(txtRcptNo.Text);
objRGH.BaseCity_Idno = Convert.ToInt64(ddlFromCity.SelectedValue);
objRGH.Rcpt_date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text));
objRGH.Chln_IdNo = Convert.ToInt64(ddlChallan.SelectedValue);
objRGH.Driver_IdNo = Convert.ToInt64(hidDriverIdno.Value);
objRGH.Inst_No = Convert.ToInt64(Convert.ToString(txtInstNo.Text) == "" ? 0 : Convert.ToInt64(txtInstNo.Text));
objRGH.Date_Added = System.DateTime.Now;
objRGH.Date_Modified = null;
objRGH.Bank_Idno = Convert.ToInt32(ddlCustmerBank.SelectedValue);
objRGH.RcptType_Idno = Convert.ToInt32(ddlRcptTyp.SelectedValue);
objRGH.UserIdno = Convert.ToInt64(Session["UserIdno"]);
if (txtInstDate.Text == "")
{
objRGH.Inst_Dt = null;
}
else
{
objRGH.Inst_Dt = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtInstDate.Text));
}
objRGH.Remark = Convert.ToString(TxtRemark.Text);
objRGH.Year_IdNo = Convert.ToInt32(ddldateRange.SelectedValue);
objRGH.Amnt = Convert.ToDouble(txtAmount.Text.Trim());
Int64 value = 0;
using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
{
if (string.IsNullOrEmpty(hidid.Value) == true)
{
value = obj.Insert(objRGH);
}
else
{
value = obj.Update(objRGH, Convert.ToInt32((Convert.ToString(hidid.Value) == "" ? 0 : Convert.ToInt32(hidid.Value))));
}
if (value > 0)
{
if (this.PostIntoAccounts(Convert.ToDouble(txtAmount.Text), value, "PTD", 0, 0, 0, 0, 0, Convert.ToInt32(ddldateRange.SelectedValue)) == true)
{
obj.UpdateIsPosting(value);
if ((string.IsNullOrEmpty(hidid.Value) == false))
{
if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == false))
{
ShowMessage("Record Update successfully");
this.Clear();
ddlFromCity_SelectedIndexChanged(null, null);
}
else if (value == -1)
{
ShowMessageErr("Pay No. Already Exist");
}
else if (string.IsNullOrEmpty(hidid.Value) == false)
{
ShowMessageErr("Record Not Update");
}
}
else
{
if (value > 0 && (string.IsNullOrEmpty(hidid.Value) == true))
{
ShowMessage("Record Saved successfully");
this.Clear();
ddlFromCity_SelectedIndexChanged(null, null);
}
else if (value == -1)
{
ShowMessageErr("Pay No. Already Exist");
}
else if ((string.IsNullOrEmpty(hidid.Value) == true))
{
ShowMessageErr("Record Not Saved successfully");
}
}
tScope.Complete();
}
else
{
if (string.IsNullOrEmpty(hidpostingmsg.Value) == true)
{
if (string.IsNullOrEmpty(Convert.ToString(hidid.Value)) == false)
{
hidpostingmsg.Value = "Record(s) not updated.";
}
else
{
hidpostingmsg.Value = "Record(s) not saved.";
}
tScope.Dispose();
}
tScope.Dispose();
ScriptManager.RegisterStartupScript(this, this.GetType(), "hwa", "PassMessageError('" + Convert.ToString(hidpostingmsg.Value) + "')", true);
return;
}
}
else
{
if (string.IsNullOrEmpty(Convert.ToString(hidid.Value)) == false)
{
hidpostingmsg.Value = "Record(s) not updated.";
}
else
{
hidpostingmsg.Value = "Record(s) not saved.";
}
tScope.Dispose();
ScriptManager.RegisterStartupScript(this, this.GetType(), "hwa", "PassMessageError('" + Convert.ToString(hidid.Value) + "')", true);
return;
}
}
this.BindMaxNo(Convert.ToInt32(Convert.ToString(ddlFromCity.SelectedValue) == "" ? 0 : Convert.ToInt32(ddlFromCity.SelectedValue)), Convert.ToInt32(Convert.ToString(ddldateRange.SelectedValue) == "" ? 0 : Convert.ToInt32(ddldateRange.SelectedValue)));
}
