/// <summary>
/// Insert records in VchrDetl table
/// </summary>
public Int64 InsertInVchrDetl(Int64 VchrIdno, Int64 AcntIdno, string NarrText, double AcntAmnt, byte AmntType, byte InstType, string InstNo, bool DetlHidn,
DateTime?BankDate, string CustBank, int CompIdno)
{
Int64 intValue = 0;
VchrDetl objVchrDetl = new VchrDetl();
objVchrDetl.Vchr_Idno = VchrIdno;
objVchrDetl.Acnt_Idno = AcntIdno;
objVchrDetl.Narr_Text = NarrText;
objVchrDetl.Acnt_Amnt = AcntAmnt;
objVchrDetl.Amnt_Type = AmntType;
objVchrDetl.Inst_Type = InstType;
objVchrDetl.Inst_No = InstNo;
objVchrDetl.Detl_Hidn = DetlHidn;
objVchrDetl.Bank_Date = BankDate;
objVchrDetl.Cust_Bank = CustBank;
objVchrDetl.Comp_Idno = CompIdno;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
db.VchrDetls.AddObject(objVchrDetl);
db.SaveChanges();
intValue = Convert.ToInt64(objVchrDetl.Vchr_Idno);
}
catch (Exception ex)
{
intValue = 0;
// using WebTransport.Classes. ApplicationFunction.ErrorLog(ex.ToString());
}
}
return(intValue);
}
private void Populate(Int64 Id)
{
VchrDetl BankDate = objBankReConciliationDAL.FetchBankDateById(Id);
VchrHead TranDate = objBankReConciliationDAL.FetchBankDateByvchrId(Convert.ToInt64(BankDate.Vchr_Idno));
objBankReConciliationDAL = null;
if (BankDate != null)
{
hidTranDate.Value = Convert.ToDateTime(TranDate.Vchr_Date).ToString("dd-MM-yyyy");
txtInstDate.Text = string.IsNullOrEmpty(Convert.ToString(BankDate.Bank_Date)) ? DateTime.Now.Date.ToString("dd-MM-yyyy") : Convert.ToDateTime(BankDate.Bank_Date).ToString("dd-MM-yyyy") == "01-01-1900" ? DateTime.Now.Date.ToString("dd-MM-yyyy") : Convert.ToDateTime(BankDate.Bank_Date).ToString("dd-MM-yyyy");
hidacntheadid.Value = BankDate.VchrDetl_Idno.ToString();
}
}
public int Update(DateTime BankDate, int intVchrDetlIdno)
{
int intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
VchrDetl objVchrDetl = (from mast in db.VchrDetls
where mast.VchrDetl_Idno == intVchrDetlIdno
select mast).FirstOrDefault();
if (objVchrDetl != null)
{
objVchrDetl.Bank_Date = BankDate;
db.SaveChanges();
intValue = intVchrDetlIdno;
}
}
}
catch (Exception ex)
{
}
return(intValue);
}
