public bool CloseRecruitmentQaid(int Id, RecruitmentQaid recruitmentQaid)
{
var CreditSum = _context.RecruitmentQaidDetails.Where(x => x.QaidId == recruitmentQaid.Id).Sum(x => x.Credit);
var DebitSum = _context.RecruitmentQaidDetails.Where(x => x.QaidId == recruitmentQaid.Id).Sum(x => x.Debit);
decimal reminder = 1;
if (CreditSum > 0 && DebitSum > 0)
{
reminder = (decimal)(CreditSum - DebitSum);
}
if (reminder == 0)
{
RecruitmentQaid existrecruitmentQaid = GetRecruitmentQaidById(Id);
if (existrecruitmentQaid == null)
{
return(false);
}
existrecruitmentQaid.StatusId = (int)EnumHelper.RecruitmentQaidStatus.Close;
_context.Update(existrecruitmentQaid);
_context.SaveChanges();
}
return(true);
}
public bool RemoveRecruitmentQaid(int Id)
{
RecruitmentQaid recruitmentQaid = GetRecruitmentQaidById(Id);
if (recruitmentQaid == null)
{
return(false);
}
_context.Remove(recruitmentQaid);
_context.SaveChanges();
return(true);
}
public int AddRecruitmentQaid(RecruitmentQaid recruitmentQaid)
{
recruitmentQaid.StatusId = (int)EnumHelper.RecruitmentQaidStatus.Open;
var getCurrentFinancialPeriod = _context.FinancialPeriods.Where(x => x.FinancialPeriodStatusId == (int)EnumHelper.FinancPeriodStatus.CURRENT).SingleOrDefault();
if (getCurrentFinancialPeriod != null)
{
recruitmentQaid.FinancialPeriodId = getCurrentFinancialPeriod.Id;
}
_context.RecruitmentQaids.Add(recruitmentQaid);
_context.SaveChanges();
return(recruitmentQaid.Id);
}
public bool UpdateRecruitmentQaid(int Id, RecruitmentQaid recruitmentQaid)
{
RecruitmentQaid existrecruitmentQaid = GetRecruitmentQaidById(Id);
if (existrecruitmentQaid == null)
{
return(false);
}
existrecruitmentQaid.QaidDate = recruitmentQaid.QaidDate;
existrecruitmentQaid.TypeId = recruitmentQaid.TypeId;
_context.Update(existrecruitmentQaid);
_context.SaveChanges();
return(true);
}
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);
}
