// Remove public bool RemoveRecruitmentQaidDetail(int Id) { RecruitmentQaidDetail details = GetRecruitmentQaidDetailById(Id); if (details == null) { return(false); } _context.Remove(details); _context.SaveChanges(); return(true); }
// Update public bool UpdateRecruitmentQaidDetail(int Id, RecruitmentQaidDetail del) { RecruitmentQaidDetail existdetails = GetRecruitmentQaidDetailById(Id); if (existdetails == null) { return(false); } existdetails.TypeId = del.TypeId; existdetails.Note = del.Note; existdetails.AccountTreeId = del.AccountTreeId; existdetails.Credit = del.Credit; existdetails.Debit = del.Debit; _context.Update(existdetails); _context.SaveChanges(); return(true); }
// Add public int AddRecruitmentQaidDetail(RecruitmentQaidDetail del) { _context.RecruitmentQaidDetails.Add(del); _context.SaveChanges(); // Update In AccountTree AccountTree existAcc = _context.AccountTrees.Where(x => x.Id == del.AccountTreeId).SingleOrDefault(); if (existAcc != null) { if (del.TypeId == 1) { existAcc.Credit = existAcc.Credit + del.Credit; } else { existAcc.Debit = existAcc.Debit + del.Debit; } _context.Update(existAcc); _context.SaveChanges(); } return(del.Id); }
public int RecruitmentQaidTaking(ReceiptDoc receipt) { #region AddQaid // Add RecruitmentQaid First RecruitmentQaid qaid = new RecruitmentQaid { QaidDate = DateTime.UtcNow.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture), StatusId = (int)EnumHelper.RecruitmentQaidStatus.Open }; var getCurrentFinancialPeriod = _context.FinancialPeriods.Where(x => x.FinancialPeriodStatusId == (int)EnumHelper.FinancPeriodStatus.CURRENT).SingleOrDefault(); if (getCurrentFinancialPeriod != null) { qaid.FinancialPeriodId = getCurrentFinancialPeriod.Id; } if (receipt.ReceiptdocTypeId == (int)EnumHelper.ReceiptdocType.SnadTaking) { qaid.TypeId = (int)EnumHelper.RecruitmentQaidTypes.Take; } _context.RecruitmentQaids.Add(qaid); _context.SaveChanges(); #endregion #region DEBIT var paymentMethod = _context.PaymentMethods.Where(x => x.Id == receipt.PaymentMethodId).SingleOrDefault(); if (paymentMethod != null) { // Add RecruitmentQaidDetails ------DEBIT RecruitmentQaidDetail detailDebit = new RecruitmentQaidDetail { QaidId = qaid.Id, Debit = receipt.Amount, TypeId = (int)EnumHelper.RecruitmentQaidDetailType.Debit, AccountTreeId = paymentMethod.AccountTreeId, Note = "" }; _context.RecruitmentQaidDetails.Add(detailDebit); _context.SaveChanges(); // change In AccountTree For Debit Account AccountTree existAcc = _context.AccountTrees.Where(x => x.Id == detailDebit.AccountTreeId).SingleOrDefault(); if (existAcc != null) { existAcc.Debit = existAcc.Debit + detailDebit.Debit; _context.Update(existAcc); _context.SaveChanges(); } } #endregion #region CREDIT var customer = _context.Customers.Where(x => x.Id == receipt.CustomerId).SingleOrDefault(); if (customer != null) { // Add RecruitmentQaidDetails ------Credit RecruitmentQaidDetail detailCredit = new RecruitmentQaidDetail { QaidId = qaid.Id, Credit = receipt.Amount, TypeId = (int)EnumHelper.RecruitmentQaidDetailType.Credit, AccountTreeId = customer.AccountTreeId, Note = "" }; _context.RecruitmentQaidDetails.Add(detailCredit); _context.SaveChanges(); // change In AccountTree For Credit Account AccountTree existAccCredit = _context.AccountTrees.Where(x => x.Id == detailCredit.AccountTreeId).SingleOrDefault(); if (existAccCredit != null) { existAccCredit.Credit = existAccCredit.Credit + detailCredit.Credit; _context.Update(existAccCredit); _context.SaveChanges(); } } #endregion return(qaid.Id); }
public int RecruitmentQaid(ForeignAgencyTransfer foreignAgencyTransfer) { #region AddQaid // Add Qaid First RecruitmentQaid qaid = new RecruitmentQaid { QaidDate = DateTime.UtcNow.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture), StatusId = (int)EnumHelper.RecruitmentQaidStatus.Open }; var getCurrentFinancialPeriod = _context.FinancialPeriods.Where(x => x.FinancialPeriodStatusId == (int)EnumHelper.FinancPeriodStatus.CURRENT).SingleOrDefault(); if (getCurrentFinancialPeriod != null) { qaid.FinancialPeriodId = getCurrentFinancialPeriod.Id; } qaid.TypeId = (int)EnumHelper.RecruitmentQaidTypes.Transfer; _context.RecruitmentQaids.Add(qaid); _context.SaveChanges(); #endregion #region DEBIT var foreignAgency = _context.ForeignAgencies.Where(x => x.Id == foreignAgencyTransfer.ForeignAgencyId).SingleOrDefault(); if (foreignAgency != null) { // Add RecruitmentQaidDetails DEBIT RecruitmentQaidDetail detailDebit = new RecruitmentQaidDetail { QaidId = qaid.Id, Debit = foreignAgencyTransfer.Amount, TypeId = (int)EnumHelper.RecruitmentQaidDetailType.Debit, AccountTreeId = foreignAgency.AccountTreeId, Note = "حوالة" }; _context.RecruitmentQaidDetails.Add(detailDebit); _context.SaveChanges(); // change In AccountTree For Debit Account ---------------------------------------- AccountTree existAcc = _context.AccountTrees.Where(x => x.Id == detailDebit.AccountTreeId).SingleOrDefault(); if (existAcc != null) { existAcc.Debit = existAcc.Debit + detailDebit.Debit; _context.Update(existAcc); _context.SaveChanges(); } } #endregion #region CREDIT var paymentMethod = _context.PaymentMethods.Where(x => x.Id == foreignAgencyTransfer.PaymentMethodId).SingleOrDefault(); if (paymentMethod != null) { // Add RecruitmentQaidDetails RecruitmentQaidDetail detailCredit = new RecruitmentQaidDetail { QaidId = qaid.Id, Credit = foreignAgencyTransfer.Amount, TypeId = (int)EnumHelper.RecruitmentQaidDetailType.Credit, AccountTreeId = paymentMethod.AccountTreeId, Note = "حوالة " }; _context.RecruitmentQaidDetails.Add(detailCredit); _context.SaveChanges(); // change In AccountTree For Credit Account --------------------------------------------- AccountTree existAccCredit = _context.AccountTrees.Where(x => x.Id == detailCredit.AccountTreeId).SingleOrDefault(); if (existAccCredit != null) { existAccCredit.Credit = existAccCredit.Credit + detailCredit.Credit; _context.Update(existAccCredit); _context.SaveChanges(); } } #endregion return(qaid.Id); }