public int Deletefile(int VchrIdno, Int64 UserIdno, string con) { int Value = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required)) { List <VchrDetl> objVchrDetl = (from obj in db.VchrDetls where obj.Vchr_Idno == VchrIdno select obj).ToList(); if (objVchrDetl != null) { SqlParameter[] objSqlPara = new SqlParameter[3]; objSqlPara[0] = new SqlParameter("@Action", "DeleteVoucherEntry"); objSqlPara[1] = new SqlParameter("@Idno", VchrIdno); objSqlPara[2] = new SqlParameter("@UserIdno", UserIdno); Int32 del = SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "spDeleteFunctionality", objSqlPara); foreach (var a in objVchrDetl) { db.DeleteObject(a); } db.SaveChanges(); var objVchrCost = (from obj in db.VchrCostDetls where obj.Vchr_Idno == VchrIdno select obj).ToList(); if (objVchrCost != null) { foreach (var lst in objVchrCost) { db.DeleteObject(lst); db.SaveChanges(); } } VchrHead objHead = (from objH in db.VchrHeads where objH.Vchr_Idno == VchrIdno select objH).FirstOrDefault(); if (objHead != null) { db.DeleteObject(objHead); db.SaveChanges(); Value = 1; tScope.Complete(); } } } } } catch { } return(Value); }
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(); } }
/// <summary> /// Insert records in VchrHead table /// </summary> public Int64 InsertInVchrHead(DateTime VchrDate, byte VchrType, Int64 VchrMode, string VchrNarr, bool VchrHidn, byte VchrSusp, string VchrFrm, Int64 AcntIdno, Int16 Printed, Int64 SbillNo, DateTime?SbillDate, Int64 VchrNo, double DcnNo, int YearIdno, int CompIdno, int UserIdno ) { Int64 intValue = 0; VchrHead objVchrHead = new VchrHead(); objVchrHead.Vchr_Date = VchrDate; objVchrHead.Vchr_Type = VchrType; objVchrHead.Vchr_Mode = VchrMode; objVchrHead.Vchr_Narr = VchrNarr; objVchrHead.Vchr_Hidn = VchrHidn; objVchrHead.Vchr_Susp = VchrSusp; objVchrHead.Vchr_Frm = VchrFrm; objVchrHead.Acnt_Idno = AcntIdno; objVchrHead.Printed = Printed; objVchrHead.Sbill_No = 0; objVchrHead.Sbill_Date = null; if (VchrNo > 0) { objVchrHead.Vchr_No = VchrNo; } else { objVchrHead.Vchr_No = this.GetMaxVchrNo(VchrType, CompIdno, YearIdno); } objVchrHead.Dcn_No = DcnNo; objVchrHead.Year_Idno = YearIdno; objVchrHead.Comp_Idno = CompIdno; objVchrHead.User_Idno = UserIdno; objVchrHead.User_Type = 0; objVchrHead.VchrFor_Idno = 0; objVchrHead.VchrManual_No = ""; objVchrHead.Date_Modified = SbillDate; objVchrHead.Date_Added = VchrDate;// ApplicationFunction.GetIndianDateTime().Date; using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { try { db.VchrHeads.AddObject(objVchrHead); db.SaveChanges(); intValue = objVchrHead.Vchr_Idno; } catch (Exception ex) { intValue = 0; // ApplicationFunction.ErrorLog(ex.ToString()); } } return(intValue); }