public IActionResult PostPartner([FromBody] PartenerModel partnerModel)
{
if (ModelState.IsValid)
{
if (partnerModel.IssueDate == "" || partnerModel.IssueDate == null)
{
partnerModel.IssueDate = DateTime.Now.ToString("d/M/yyyy");
}
if (partnerModel.Date == "" || partnerModel.Date == null)
{
partnerModel.Date = DateTime.Now.ToString("d/M/yyyy");
}
var model = _mapper.Map <Partner>(partnerModel);
if (model == null)
{
return(Ok(0));
}
var Check = unitOfWork.PartnerRepository.Get();
if (Check.Any(m => m.Code == partnerModel.Code))
{
return(Ok(2));
}
else
{
if (Check.Any(m => m.NameAR == partnerModel.NameAR))
{
return(Ok(2));
}
else
{
unitOfWork.PartnerRepository.Insert(model);
var Result = unitOfWork.Save();
if (Result == 200)
{
var UserID = loggerHistory.getUserIdFromRequest(Request);
loggerHistory.InsertUserLog(UserID, "بطاقه الشركه", "اضافه الشركه", true);
partnerModel.Count = unitOfWork.PartnerRepository.Count();
return(Ok(4));
}
else if (Result == 501)
{
return(Ok(5));
}
else
{
return(Ok(6));
}
}
}
}
else
{
return(Ok(3));
}
}
public IActionResult FirstOpen()
{
var x = Request.Headers;
PartenerModel model = new PartenerModel();
var count = unitOfWork.PartnerRepository.Count();
if (count > 0)
{
model.LastCode = unitOfWork.PartnerRepository.Last().Code;
model.Count = count;
}
var countries = unitOfWork.CountryRepository.Get();
if (countries.Count() > 0)
{
model.Countries = countries.Select(m => new CountryModel
{
CountryID = m.CountryID,
NameAR = m.NameAR,
NameEN = m.NameEN
});
}
return(Ok(model));
}
public IActionResult PutPartner(int id, [FromBody] PartenerModel partnerModel)
{
if (id < 0)
{
return(Ok(1));
}
if (ModelState.IsValid)
{
if (partnerModel.IssueDate == "" || partnerModel.IssueDate == null)
{
partnerModel.IssueDate = DateTime.Now.ToString("d/M/yyyy");
}
if (partnerModel.Date == "" || partnerModel.Date == null)
{
partnerModel.Date = DateTime.Now.ToString("d/M/yyyy");
}
var check1 = unitOfWork.PartnerRepository.Get(NoTrack: "NoTrack", filter: a => a.PartnerID == id);
if (check1 != null)
{
var model = _mapper.Map <Partner>(partnerModel);
if (model == null)
{
return(Ok(0));
}
var Check = unitOfWork.PartnerRepository.Get(NoTrack: "NoTrack");
if (!Check.Any(m => m.Code == partnerModel.Code))
{
unitOfWork.PartnerRepository.Update(model);
var Result = unitOfWork.Save();
if (Result == 200)
{
var UserID = loggerHistory.getUserIdFromRequest(Request);
loggerHistory.InsertUserLog(UserID, "بطاقه الشركه", "تعديل الشركه", true);
partnerModel.Count = unitOfWork.PartnerRepository.Count();
return(Ok(4));
}
else if (Result == 501)
{
return(Ok(5));
}
else
{
return(Ok(6));
}
}
else
{
if (Check.Any(m => m.Code == partnerModel.Code && m.PartnerID == id))
{
unitOfWork.PartnerRepository.Update(model);
var Result = unitOfWork.Save();
if (Result == 200)
{
var UserID = loggerHistory.getUserIdFromRequest(Request);
loggerHistory.InsertUserLog(UserID, "بطاقه الشركه", "تعديل الشركه", true);
partnerModel.Count = unitOfWork.PartnerRepository.Count();
return(Ok(4));
}
else if (Result == 501)
{
return(Ok(5));
}
else
{
return(Ok(6));
}
}
else
{
return(Ok(2));
}
}
}
else
{
return(Ok(0));
}
}
else
{
return(Ok(3));
}
}
public IActionResult Search(int TableNum, string Code)
{
switch (TableNum)
{
#region Purchase Invoice
case 1:
var PurchaseInvoiceEntitylist = unitOfWork.PurchaseInvoiceRepository.Get(filter: a => a.Code == Code).SingleOrDefault();
if (PurchaseInvoiceEntitylist != null)
{
PurchaseInvoiceModel purchaseInvoiceModel = new PurchaseInvoiceModel();
purchaseInvoiceModel.Code = PurchaseInvoiceEntitylist.Code;
purchaseInvoiceModel.PurchaseDate = PurchaseInvoiceEntitylist.Date.Value.ToString("d/M/yyyy");
purchaseInvoiceModel.PurchaseDateHijri = DateHelper.GetHijriDate(PurchaseInvoiceEntitylist.Date);
//var EmplyeeEntity = unitOfWork.EmployeeRepository.Get(filter: e => e.EmployeeID == purchaseInvoiceModel.EmployeeID).SingleOrDefault();
//purchaseInvoiceModel.EmpCode = EmplyeeEntity.Code;
//purchaseInvoiceModel.EmpNameAR = EmplyeeEntity.NameAR;
//purchaseInvoiceModel.EmpNameEN = EmplyeeEntity.NameEN;
purchaseInvoiceModel.EmployeeID = PurchaseInvoiceEntitylist.EmployeeID;
purchaseInvoiceModel.EmpNameAR = PurchaseInvoiceEntitylist.Employee.NameAR;
purchaseInvoiceModel.EmpCode = PurchaseInvoiceEntitylist.Employee.Code;
var id = unitOfWork.PurchaseOrderRepository.GetEntity(filter: a => a.PurchaseOrderID == PurchaseInvoiceEntitylist.PurchaseOrderID).PortfolioID;
var PortfolioEntity = unitOfWork.PortfolioRepository.GetEntity(filter: p => p.PortfolioID == id);
purchaseInvoiceModel.PortfolioCode = PortfolioEntity.Code;
purchaseInvoiceModel.PortfolioNameAR = PortfolioEntity.NameAR;
purchaseInvoiceModel.PortfolioNameEN = PortfolioEntity.NameEN;
purchaseInvoiceModel.PortfolioAccount = unitOfWork.PortfolioAccountRepository.GetEntity(filter: s => s.PortfolioID == id).AccountID;
purchaseInvoiceModel.DetailsModels = unitOfWork.PurchaseInvoiceDetailRepository.Get(filter: z => z.PurchaseInvoiceID == PurchaseInvoiceEntitylist.PurchaseInvoiceID).Select(a => new PurchaseInvoiceDetailModel {
BankCommission = a.BankCommission,
BankCommissionRate = a.BankCommissionRate,
NetAmmount = a.NetAmmount,
PartnerCode = a.Partner.Code,
PartnerID = a.PartnerID,
PartnerNameAR = a.Partner.NameAR,
PartnerNameEN = a.Partner.NameEN,
PurchaseInvoiceDetailID = a.PurchaseInvoiceDetailID,
PurchaseInvoiceID = a.PurchaseInvoiceID,
PurchasePrice = a.PurchasePrice,
PurchaseValue = a.PurchaseValue,
StockCount = a.StockCount,
TaxOnCommission = a.TaxOnCommission,
TaxRateOnCommission = a.TaxRateOnCommission,
});
decimal?oldNetAmmount = 0.0m;
foreach (var item in purchaseInvoiceModel.DetailsModels)
{
oldNetAmmount += item.NetAmmount;
}
purchaseInvoiceModel.newRialBalance = _stocksHelper.RialBalancUpdate(PurchaseInvoiceEntitylist.PurchaseOrder.PortfolioID, oldNetAmmount);
purchaseInvoiceModel.PurchaseOrderID = PurchaseInvoiceEntitylist.PurchaseOrderID;
purchaseInvoiceModel.SettingModel = GetSetting(2);
var EntryPurchaseInvoiceEntitylist = unitOfWork.EntryRepository.Get(filter: a => a.PurchaseInvoiceID == purchaseInvoiceModel.PurchaseInvoiceID);
purchaseInvoiceModel.EntryModel = _mapper.Map <EntryModel>(EntryPurchaseInvoiceEntitylist.SingleOrDefault());
if (EntryPurchaseInvoiceEntitylist.Count() > 0)
{
var EntryDitailsPurchaseInvoiceEntitylist = unitOfWork.EntryDetailRepository.Get(filter: d => d.EntryID == purchaseInvoiceModel.EntryModel.EntryID);
purchaseInvoiceModel.EntryModel.EntryDetailModel = _mapper.Map <IEnumerable <EntryDetailModel> >(EntryDitailsPurchaseInvoiceEntitylist);
}
return(Ok(purchaseInvoiceModel));
}
else
{
return(Ok(0));
}
#endregion
#region selling Invoice
case 2:
var SellingInvoiceEntitylist = unitOfWork.SellingInvoiceReposetory.Get(NoTrack: "NoTrack", filter: a => a.Code == Code).SingleOrDefault();
if (SellingInvoiceEntitylist.Code != null)
{
SellingInvoiceModel SellingInvoiceModel = new SellingInvoiceModel();
SellingInvoiceModel = _mapper.Map <SellingInvoiceModel>(SellingInvoiceEntitylist);
SellingInvoiceModel.SellDate = SellingInvoiceEntitylist.Date.Value.ToString("d/M/yyyy");
SellingInvoiceModel.SellDateHijri = DateHelper.GetHijriDate(SellingInvoiceEntitylist.Date);
var EmplyeeEntity = unitOfWork.EmployeeRepository.Get(filter: e => e.EmployeeID == SellingInvoiceModel.EmployeeID).SingleOrDefault();
SellingInvoiceModel.EmpCode = EmplyeeEntity.Code;
SellingInvoiceModel.EmpNameAR = EmplyeeEntity.NameAR;
SellingInvoiceModel.EmpCode = EmplyeeEntity.NameEN;
var id = unitOfWork.SellingOrderRepository.GetEntity(filter: x => x.SellingOrderID == SellingInvoiceEntitylist.SellingOrderID).PortfolioID;
var PortfolioEntity = unitOfWork.PortfolioRepository.Get(filter: p => p.PortfolioID == id).SingleOrDefault();
SellingInvoiceModel.PortfolioCode = PortfolioEntity.Code;
SellingInvoiceModel.PortfolioNameAR = PortfolioEntity.NameAR;
SellingInvoiceModel.PortfolioNameEN = PortfolioEntity.NameEN;
SellingInvoiceModel.PortfolioAccount = unitOfWork.PortfolioAccountRepository.GetEntity(filter: s => s.PortfolioID == id).AccountID;
SellingInvoiceModel.DetailsModels = unitOfWork.SellingInvoiceDetailRepository.Get(filter: z => z.SellingInvoiceID == SellingInvoiceEntitylist.SellingInvoiceID).Select(a => new SellingInvoiceDetailsModel {
BankCommission = a.BankCommission,
BankCommissionRate = a.BankCommissionRate,
NetAmmount = a.NetAmmount,
PartnerCode = a.Partner.Code,
PartnerID = a.PartnerID,
PartnerNameAR = a.Partner.NameAR,
PartnerNameEN = a.Partner.NameEN,
SelingValue = a.SelingValue,
SellingInvoiceDetailID = a.SellInvoiceDetailID,
SellingInvoiceID = a.SellingInvoiceID,
SellingPrice = a.SellingPrice,
StockCount = a.StockCount,
StocksCount = a.StockCount,
TaxRateOnCommission = a.TaxRateOnCommission,
TaxOnCommission = a.TaxOnCommission,
});
SellingInvoiceModel.SettingModel = GetSetting(1);
var EntrySellingInvoiceEntitylist = unitOfWork.EntryRepository.Get(filter: a => a.SellingInvoiceID == SellingInvoiceModel.SellingInvoiceID);
SellingInvoiceModel.EntryModel = _mapper.Map <EntryModel>(EntrySellingInvoiceEntitylist.SingleOrDefault());
if (EntrySellingInvoiceEntitylist.Count() > 0)
{
var EntryDitailsSellingInvoiceEntitylist = unitOfWork.EntryDetailRepository.Get(filter: d => d.EntryID == SellingInvoiceModel.EntryModel.EntryID);
SellingInvoiceModel.EntryModel.EntryDetailModel = _mapper.Map <IEnumerable <EntryDetailModel> >(EntryDitailsSellingInvoiceEntitylist);
}
return(Ok(SellingInvoiceModel));
}
else
{
return(Ok(0));
}
#endregion
#region Notice Creditor
case 3:
var NoticeCreditorEntityList = unitOfWork.NoticeRepository.Get(filter: a => a.Code == Code && a.Type == false);
if (NoticeCreditorEntityList.Count() > 0)
{
NoticeModel noticeModel = new NoticeModel();
noticeModel = GetNotice(NoticeCreditorEntityList.SingleOrDefault(), false);
return(Ok(noticeModel));
}
else
{
return(Ok(0));
}
#endregion
#region Notice Debitor
case 4:
var NoticeDebitorEntityList = unitOfWork.NoticeRepository.Get(filter: a => a.Code == Code && a.Type == true);
if (NoticeDebitorEntityList.Count() > 0)
{
NoticeModel noticeModel = new NoticeModel();
noticeModel = GetNotice(NoticeDebitorEntityList.SingleOrDefault(), true);
return(Ok(noticeModel));
}
else
{
return(Ok(0));
}
#endregion
#region Receipt voucher Ryal
case 5:
{
var ReceiptExchangeEntitylist = unitOfWork.ReceiptExchangeRepository.GetEntity(filter: x => x.Code == Code && x.Type == false && x.ReceiptExchangeType == true);
if (ReceiptExchangeEntitylist != null)
{
ReceiptExchangeModel receiptExchangeModel = new ReceiptExchangeModel();
receiptExchangeModel = GetReceiptExchange(ReceiptExchangeEntitylist, 5);
return(Ok(receiptExchangeModel));
}
else
{
return(Ok(0));
}
}
#endregion
#region Receipt voucher chique
case 6:
{
var ReceiptExchangeEntitylist = unitOfWork.ReceiptExchangeRepository.Get(filter: x => x.Code == Code && x.Type == false && x.ReceiptExchangeType == false).FirstOrDefault();
if (ReceiptExchangeEntitylist != null)
{
ReceiptExchangeModel receiptExchangeModel = new ReceiptExchangeModel();
receiptExchangeModel = GetReceiptExchange(ReceiptExchangeEntitylist, 5);
return(Ok(receiptExchangeModel));
}
else
{
return(Ok(0));
}
}
#endregion
#region Exchange voucher Ryal
case 7:
{
var ReceiptExchangeEntitylist = unitOfWork.ReceiptExchangeRepository.Get(filter: x => x.Code == Code && x.ReceiptExchangeType == true && x.Type == true);
if (ReceiptExchangeEntitylist.Count() > 0)
{
ReceiptExchangeModel receiptExchangeModel = new ReceiptExchangeModel();
receiptExchangeModel = GetReceiptExchange(ReceiptExchangeEntitylist.SingleOrDefault(), 6);
return(Ok(receiptExchangeModel));
}
else
{
return(Ok(0));
}
}
#endregion
#region Exchange voucher chique
case 8:
{
var ReceiptExchangeEntitylist = unitOfWork.ReceiptExchangeRepository.GetEntity(filter: x => x.Code == Code && x.Type == true && x.ReceiptExchangeType == false);
if (ReceiptExchangeEntitylist != null)
{
ReceiptExchangeModel receiptExchangeModel = new ReceiptExchangeModel();
receiptExchangeModel = GetReceiptExchange(ReceiptExchangeEntitylist, 6);
return(Ok(receiptExchangeModel));
}
else
{
return(Ok(0));
}
}
#endregion
#region Country
case 9:
{
var CountryEntityList = unitOfWork.CountryRepository.Get(filter: x => x.Code == Code || x.NameAR == Code);
if (CountryEntityList.Count() > 0)
{
CountryModel countryModel = _mapper.Map <CountryModel>(CountryEntityList.SingleOrDefault());
return(Ok(countryModel));
}
else
{
return(Ok(0));
}
}
#endregion
#region Account
case 10:
{
var AccountEntityList = unitOfWork.AccountRepository.Get(filter: x => x.Code == Code || x.NameAR == Code);
if (AccountEntityList.Count() > 0)
{
AccountModel AccountModel = _mapper.Map <AccountModel>(AccountEntityList.SingleOrDefault());
return(Ok(AccountModel));
}
else
{
return(Ok(0));
}
}
#endregion
#region Employee
case 11:
{
var EmployeeEntityList = unitOfWork.EmployeeRepository.GetEntity(filter: x => x.Code == Code);
if (EmployeeEntityList != null)
{
string date = EmployeeEntityList.BirthDate.Value.ToString("d/M/yyyy");
EmployeeModel EmployeeModel = _mapper.Map <EmployeeModel>(EmployeeEntityList);
EmployeeModel.BirthDate = date;
var EmployCardsEntityList = unitOfWork.EmployeeCardRepository.Get(filter: x => x.EmployeeID == EmployeeModel.EmployeeID);
EmployeeModel.emplCards = _mapper.Map <IEnumerable <EmployeeCardModel> >(EmployCardsEntityList);
return(Ok(EmployeeModel));
}
else
{
return(Ok(0));
}
}
#endregion
#region Partner
case 12:
{
var PartnerEntityList = unitOfWork.PartnerRepository.Get(filter: x => x.Code == Code).SingleOrDefault();
if (PartnerEntityList != null)
{
string date = PartnerEntityList.Date.ToString("d/M/yyyy");
string IssueDate = PartnerEntityList.IssueDate.Value.ToString("d/M/yyyy");
PartenerModel partnerModel = _mapper.Map <PartenerModel>(PartnerEntityList);
partnerModel.Date = date;
partnerModel.IssueDate = IssueDate;
var Countries = unitOfWork.CountryRepository.Get(filter: x => x.CountryID == partnerModel.CountryID);
partnerModel.Countries = _mapper.Map <IEnumerable <CountryModel> >(Countries);
IEnumerable <PortfolioTransaction> StocksCountList = unitOfWork.PortfolioTransactionsRepository.Get(filter: x => x.PartnerID == partnerModel.PartnerID);
partnerModel.StocksCount = 0;
for (int ii = 0; ii < StocksCountList.Count(); ii++)
{
partnerModel.StocksCount += StocksCountList.ElementAt(ii).CurrentStocksCount;
}
return(Ok(partnerModel));
}
else
{
return(Ok(0));
}
}
#endregion
#region portfolio
case 13:
{
var PortfolioEntityList = unitOfWork.PortfolioRepository.Get(filter: x => x.Code == Code || x.NameAR == Code);
if (PortfolioEntityList.Count() > 0)
{
return(Ok(GetPortfolio(PortfolioEntityList.SingleOrDefault())));
}
else
{
return(Ok(0));
}
}
#endregion
#region selling Order
case 14:
{
var sellingorder = unitOfWork.SellingOrderRepository.Get(filter: x => x.Code == Code).SingleOrDefault();
var model = _mapper.Map <SellingOrderModel>(sellingorder);
if (sellingorder != null)
{
#region Date part
if (sellingorder.OrderDate != null)
{
model.OrderDateGorg = sellingorder.OrderDate.ToString("d/M/yyyy");
model.OrderDateHigri = DateHelper.GetHijriDate(sellingorder.OrderDate);
}
#endregion
#region Details
var Details = unitOfWork.SellingOrderDetailRepository
.Get(filter: m => m.SellingOrderID == sellingorder.SellingOrderID)
.Select(m => new SellingOrderDetailModel
{
PartnerID = m.PartnerID,
PartnerNameAr = m.Partner.NameAR,
PriceType = m.PriceType,
SellingOrderID = m.SellingOrderID,
SellOrderDetailID = m.SellOrderDetailID,
StockCount = m.StockCount,
TradingValue = m.TradingValue,
PartnerCode = m.Partner.Code
});
if (Details != null)
{
model.sellingOrderDetailModels = Details;
}
#endregion
model.Count = unitOfWork.SellingOrderRepository.Count();
model.Portfoliocode = unitOfWork.PortfolioRepository.GetEntity(filter: a => a.PortfolioID == sellingorder.PortfolioID).Code;
return(Ok(model));
}
else
{
return(Ok(0));
}
}
#endregion
#region Order
case 15:
{
var Purchaseorder = unitOfWork.PurchaseOrderRepository.Get(filter: x => x.Code == Code).SingleOrDefault();
var model = _mapper.Map <PurchaseOrderModel>(Purchaseorder);
#region Date part
if (Purchaseorder.OrderDate != null)
{
model.OrderDate = Purchaseorder.OrderDate.ToString("d/M/yyyy");
model.OrderDateHijri = DateHelper.GetHijriDate(Purchaseorder.OrderDate);
}
#endregion
#region Details
var Details = unitOfWork.PurchaseOrderDetailRepository
.Get(filter: m => m.PurchaseOrderID == Purchaseorder.PurchaseOrderID)
.Select(m => new PurchaseOrderDetailModel
{
PartnerID = m.PartnerID,
PartnerNameAr = m.Partner.NameAR,
PriceType = m.PriceType,
PurchaseOrderID = m.PurchaseOrderID,
PurchaseOrderDetailID = m.PurchaseOrderDetailID,
StockCount = m.StockCount,
TradingValue = m.TradingValue,
PartnerCode = m.Partner.Code
});
if (Details != null)
{
model.purchaseordersDetailsModels = Details;
}
#endregion
model.Count = unitOfWork.PurchaseOrderRepository.Count();
model.Portfoliocode = unitOfWork.PortfolioRepository.GetEntity(filter: a => a.PortfolioID == Purchaseorder.PortfolioID).Code;
return(Ok(model));
}
#endregion
}
return(Ok("Error Table Number"));
}
