public static int SaveChallanEntry(tblChallanEntryDTO tblChallanEntryDTO) { using (var dbObject = new BRCTransportDBEntities()) { var tblChallanEntryObject = tblChallanEntryDTO.ToEntity(); if (tblChallanEntryDTO.ChallanEntryNo == 0) { dbObject.tblChallanEntries.Add(tblChallanEntryObject); } else { tblChallanEntryObject = dbObject.tblChallanEntries.Find(tblChallanEntryDTO.ChallanEntryNo); tblChallanEntryObject.ChallanId = tblChallanEntryDTO.ChallanId; tblChallanEntryObject.ChallanId = tblChallanEntryDTO.ChallanId; tblChallanEntryObject.BkgStnCode = tblChallanEntryDTO.BkgStnCode; tblChallanEntryObject.CNNoWithAlphaCode = tblChallanEntryDTO.CNNoWithAlphaCode; tblChallanEntryObject.PackagesNos = tblChallanEntryDTO.PackagesNos; tblChallanEntryObject.PackagesMethod = tblChallanEntryDTO.PackagesMethod; tblChallanEntryObject.SaidToContain = tblChallanEntryDTO.SaidToContain; tblChallanEntryObject.ActualWeightKgs = tblChallanEntryDTO.ActualWeightKgs; tblChallanEntryObject.DestinationName = tblChallanEntryDTO.DestinationName; } dbObject.SaveChanges(); return(tblChallanEntryObject.ChallanEntryNo); } }
public static int Save(tblMRNoteDTO tblMRNoteDTO) { using (var dbObject = new BRCTransportDBEntities()) { var tblMRNote = tblMRNoteDTO.ToEntity(); if (tblMRNoteDTO.MRId == 0) { dbObject.tblMRNotes.Add(tblMRNote); } else { tblMRNote = dbObject.tblMRNotes.Find(tblMRNoteDTO.MRId); tblMRNote.MrNo = tblMRNoteDTO.MrNo; tblMRNote.BillId = tblMRNoteDTO.BillId; tblMRNote.MRDate = tblMRNoteDTO.MRDate; tblMRNote.RecievedFrom = tblMRNoteDTO.RecievedFrom; tblMRNote.LocationFrom = tblMRNoteDTO.LocationFrom; tblMRNote.LocationTo = tblMRNoteDTO.LocationTo; tblMRNote.NoofPackages = tblMRNoteDTO.NoofPackages; tblMRNote.Weight = tblMRNoteDTO.Weight; tblMRNote.AmountRecieved = tblMRNoteDTO.AmountRecieved; tblMRNote.WayOfRecieve = tblMRNoteDTO.WayOfRecieve; tblMRNote.Fright = tblMRNoteDTO.Fright; tblMRNote.StCharges = tblMRNoteDTO.StCharges; tblMRNote.Hamali = tblMRNoteDTO.Hamali; tblMRNote.Other1 = tblMRNoteDTO.Other1; tblMRNote.Other2 = tblMRNoteDTO.Other2; tblMRNote.Other3 = tblMRNoteDTO.Other3; tblMRNote.Other4 = tblMRNoteDTO.Other4; tblMRNote.TotalAmount = tblMRNoteDTO.TotalAmount; } dbObject.SaveChanges(); return(tblMRNote.MRId); } }
public static tblMRNoteDTO Get(int mrId) { using (var dbObject = new BRCTransportDBEntities()) { return(dbObject.tblMRNotes.Find(mrId).ToDTO()); } }
public static List <tblMRNoteDTO> GetBillMRNote(int billId) { using (var dbObject = new BRCTransportDBEntities()) { return(dbObject.tblMRNotes.Where(mrNOte => mrNOte.BillId == billId).ToList().ToDTOs()); } }
public static int Save(tblAccountsMasterDTO tblAccountsMasterDTO) { using (var dbObject = new BRCTransportDBEntities()) { var tblAccountsMaster = tblAccountsMasterDTO.ToEntity(); if (tblAccountsMasterDTO.AccountId == 0) { dbObject.tblAccountsMasters.Add(tblAccountsMaster); } else { tblAccountsMaster = dbObject.tblAccountsMasters.Find(tblAccountsMasterDTO.AccountId); tblAccountsMaster.AccountName = tblAccountsMasterDTO.AccountName; tblAccountsMaster.AccountType = tblAccountsMasterDTO.AccountType; tblAccountsMaster.AccountNo = tblAccountsMasterDTO.AccountNo; tblAccountsMaster.Addrees = tblAccountsMasterDTO.Addrees; tblAccountsMaster.PhoneNo = tblAccountsMasterDTO.PhoneNo; tblAccountsMaster.OpeningBalance = tblAccountsMasterDTO.OpeningBalance; tblAccountsMaster.OpeningDate = tblAccountsMasterDTO.OpeningDate; tblAccountsMaster.Description = tblAccountsMasterDTO.Description; } dbObject.SaveChanges(); return(tblAccountsMaster.AccountId); } }
public static int SaveBillEntry(tblBillEntryDTO tblBillEntryDTO) { using (var dbObject = new BRCTransportDBEntities()) { var tblBillEntryObject = tblBillEntryDTO.ToEntity(); if (tblBillEntryDTO.BillOrderId == 0) { dbObject.tblBillEntries.Add(tblBillEntryObject); } else { tblBillEntryObject = dbObject.tblBillEntries.Find(tblBillEntryDTO.BillOrderId); tblBillEntryObject.BillId = tblBillEntryDTO.BillId; tblBillEntryObject.BookingOldBrCode = tblBillEntryDTO.BookingOldBrCode; tblBillEntryObject.OldBillNo = tblBillEntryDTO.OldBillNo; tblBillEntryObject.OldBillDate = tblBillEntryDTO.OldBillDate; tblBillEntryObject.DestnCode = tblBillEntryDTO.DestnCode; tblBillEntryObject.Particulars = tblBillEntryDTO.Particulars; tblBillEntryObject.ChargedWeight = tblBillEntryDTO.ChargedWeight; tblBillEntryObject.Rate = tblBillEntryDTO.Rate; tblBillEntryObject.Amount = tblBillEntryDTO.Amount; } dbObject.SaveChanges(); return(tblBillEntryObject.BillOrderId); } }
public static tblConsigneeDTO Get(int consigneeId) { using (var dbObject = new BRCTransportDBEntities()) { return(dbObject.tblConsignees.Find(consigneeId).ToDTO()); } }
public static tblBillEntryDTO GetBillEntry(int billOrderId) { using (var dbObject = new BRCTransportDBEntities()) { return(dbObject.tblBillEntries.Find(billOrderId).ToDTO()); } }
public static List <tblBillEntryDTO> GetBillEntryList(int billId) { using (var dbObject = new BRCTransportDBEntities()) { return(dbObject.tblBillEntries.Where(billEntry => billEntry.BillId == billId).ToDTOs()); } }
public static List <tblConsignmentNoteDTO> GetAll() { using (var dbObject = new BRCTransportDBEntities()) { return(dbObject.tblConsignmentNotes.ToList().ToDTOs()); } }
public static tblAccountsMasterDTO Get(int companyId) { using (var dbObject = new BRCTransportDBEntities()) { return(dbObject.tblAccountsMasters.Find(companyId).ToDTO()); } }
public static tblChallanEntryDTO GetChallanEntry(int ChallanOrderId) { using (var dbObject = new BRCTransportDBEntities()) { return(dbObject.tblChallanEntries.Find(ChallanOrderId).ToDTO()); } }
public static List <tblAccountsMasterDTO> GetAll() { using (var dbObject = new BRCTransportDBEntities()) { return(dbObject.tblAccountsMasters.ToList().ToDTOs()); } }
public static List <tblChallanDTO> GetAll() { using (var dbObject = new BRCTransportDBEntities()) { return(dbObject.tblChallans.ToList().ToDTOs()); } }
public static List <tblChallanEntryDTO> GetChallanEntryList(int ChallanId) { using (var dbObject = new BRCTransportDBEntities()) { return(dbObject.tblChallanEntries.Where(ChallanEntry => ChallanEntry.ChallanId == ChallanId).ToDTOs()); } }
public static int Save(tblTransactionDTO tblTransactionDTO) { using (var dbObject = new BRCTransportDBEntities()) { var tblTransaction = tblTransactionDTO.ToEntity(); if (tblTransactionDTO.TransactionId == 0) { dbObject.tblTransactions.Add(tblTransaction); } else { tblTransaction = dbObject.tblTransactions.Find(tblTransactionDTO.TransactionId); tblTransaction.AccountId = tblTransactionDTO.AccountId; tblTransaction.TDate = tblTransactionDTO.TDate; tblTransaction.DrAmount = tblTransactionDTO.DrAmount; tblTransaction.CrAmount = tblTransactionDTO.CrAmount; tblTransaction.Recievedby = tblTransactionDTO.Recievedby; tblTransaction.PaidBy = tblTransactionDTO.PaidBy; tblTransaction.Description = tblTransactionDTO.Description; tblTransaction.ChequeNo = tblTransactionDTO.ChequeNo; tblTransaction.ChequeDate = tblTransactionDTO.ChequeDate; } dbObject.SaveChanges(); return(tblTransaction.TransactionId); } }
public static bool Delete(int consigneeId) { using (var dbObject = new BRCTransportDBEntities()) { var tblConsignee = dbObject.tblConsignees.Find(consigneeId); dbObject.tblConsignees.Remove(tblConsignee); dbObject.SaveChanges(); return(true); } }
public static bool Delete(int companyId) { using (var dbObject = new BRCTransportDBEntities()) { var tblAccountsMaster = dbObject.tblAccountsMasters.Find(companyId); dbObject.tblAccountsMasters.Remove(tblAccountsMaster); dbObject.SaveChanges(); return(true); } }
public static bool Delete(int transactionId) { using (var dbObject = new BRCTransportDBEntities()) { var tblTransaction = dbObject.tblTransactions.Find(transactionId); dbObject.tblTransactions.Remove(tblTransaction); dbObject.SaveChanges(); return(true); } }
public static bool Delete(int mrId) { using (var dbObject = new BRCTransportDBEntities()) { var tblMRNote = dbObject.tblMRNotes.Find(mrId); dbObject.tblMRNotes.Remove(tblMRNote); dbObject.SaveChanges(); return(true); } }
public static bool DeleteChallanEntry(int ChallanEntryOrderId) { using (var dbObject = new BRCTransportDBEntities()) { var tblChallanEntry = dbObject.tblChallanEntries.Find(ChallanEntryOrderId); dbObject.tblChallanEntries.Remove(tblChallanEntry); dbObject.SaveChanges(); return(true); } }
public static tblChallanDTO Get(int ChallanId) { using (var dbObject = new BRCTransportDBEntities()) { tblChallanDTO temp; temp = dbObject.tblChallans.Find(ChallanId).ToDTO(); temp.ChallanEntryList = dbObject.tblChallanEntries.Where(h => h.ChallanId == ChallanId).ToList().ToDTOs(); return(temp); } }
public static tblBillDTO Get(int billId) { using (var dbObject = new BRCTransportDBEntities()) { tblBillDTO temp = new tblBillDTO(); temp = dbObject.tblBills.Find(billId).ToDTO(); temp.BillEntryList = dbObject.tblBillEntries.Where(h => h.BillId == billId).ToList().ToDTOs(); return(temp); } }
public static bool CheckDuplicateConsignmentNoteNo(int ConsignmentId, int ConsignmentNoteNo) { using (var dbObject = new BRCTransportDBEntities()) { var ConsignmentNoteList = dbObject.tblConsignmentNotes.Where(s => s.ConsignmentNoteNo == ConsignmentNoteNo && s.ConsignmentId != ConsignmentId).ToList(); if (ConsignmentNoteList.Count() > 0) { return(true); } } return(false); }
public static bool CheckDuplicateMRNo(int mrId, int mrNo) { using (var dbObject = new BRCTransportDBEntities()) { var billList = dbObject.tblMRNotes.Where(s => s.MrNo == mrNo && s.MRId != mrId).ToList(); if (billList.Count() > 0) { return(true); } } return(false); }
public static bool CheckDuplicateCodeExists(string code, Int32 consignorId) { using (var dbObject = new BRCTransportDBEntities()) { var consignorList = dbObject.tblConsignors.Where(s => s.Code == code && s.ConsignorId != consignorId).ToList(); if (consignorList.Count() > 0) { return(true); } } return(false); }
public static bool CheckDuplicateAccount(string accountName, int accountId) { using (var dbObject = new BRCTransportDBEntities()) { var accountsMastersList = dbObject.tblAccountsMasters.Where(s => string.Compare(s.AccountName, accountName, StringComparison.CurrentCultureIgnoreCase) == 0 && s.AccountId != accountId).ToList(); if (accountsMastersList.Count() > 0) { return(true); } } return(false); }
public static bool CheckDuplicateChallanNo(int ChallanId, int ChallanNo) { using (var dbObject = new BRCTransportDBEntities()) { var ChallanList = dbObject.tblChallans.Where(s => s.ChallanNo == ChallanNo && s.ChallanId != ChallanId).ToList(); if (ChallanList.Count() > 0) { return(true); } } return(false); }
public static bool CheckDuplicateBillNo(int billId, int billNo) { using (var dbObject = new BRCTransportDBEntities()) { var billList = dbObject.tblBills.Where(s => s.BillNo == billNo && s.BillId != billId).ToList(); if (billList.Count() > 0) { return(true); } } return(false); }
public static int Save(tblBillDTO tblBillDTO) { using (var dbObject = new BRCTransportDBEntities()) { var tblBillObject = tblBillDTO.ToEntity(); if (tblBillDTO.BillId == 0) { dbObject.tblBills.Add(tblBillObject); if (tblBillDTO.BillEntryList != null) { foreach (var billEntry in tblBillDTO.BillEntryList) { billEntry.BillId = tblBillDTO.BillId; dbObject.tblBillEntries.Add(billEntry.ToEntity()); } } } else { tblBillObject = dbObject.tblBills.Find(tblBillDTO.BillId); tblBillObject.BillNo = tblBillDTO.BillNo; tblBillObject.BillDate = tblBillDTO.BillDate; tblBillObject.PartyId = tblBillDTO.PartyId; tblBillObject.BranchCode = tblBillDTO.BranchCode; tblBillObject.PaymentDueDate = tblBillDTO.PaymentDueDate; tblBillObject.BillType = tblBillDTO.BillType; tblBillObject.BasicOfChargesGC = tblBillDTO.BasicOfChargesGC; tblBillObject.Enclosure = tblBillDTO.Enclosure; tblBillObject.ServiceTaxThrough = tblBillDTO.ServiceTaxThrough; tblBillObject.CheckedBy = tblBillDTO.CheckedBy; tblBillObject.GrandTotal = tblBillDTO.GrandTotal; tblBillObject.ServiceTaxRegdNo = tblBillDTO.ServiceTaxRegdNo; List <tblBillEntry> entry = new List <tblBillEntry>(); entry = dbObject.tblBillEntries.Where(h => h.BillId == tblBillDTO.BillId).ToList(); foreach (var item in entry) { dbObject.tblBillEntries.Remove(item); } if (tblBillDTO.BillEntryList != null) { foreach (var billEntry in tblBillDTO.BillEntryList) { billEntry.BillId = tblBillDTO.BillId; dbObject.tblBillEntries.Add(billEntry.ToEntity()); } } } dbObject.SaveChanges(); return(tblBillObject.BillId); } }