public async Task <IActionResult> GetReplacementList(SearchPartNo searchPartNo)
{
searchPartNo.partNo = HttpContext.Request.Query["search"].ToString();
GetReplacementListResponse response = _iAdminReplacementService.GetReplacementList(searchPartNo);
return(Ok(response));
}
public async Task <IActionResult> SaveReplacementPrice(UpdateReplacementPrice UpdateReplacementPrice)
{
UpdateReplacementPrice.PartNo = Convert.ToInt32(HttpContext.Request.Query["PartNo"].ToString());
UpdateReplacementPrice.Qty = Convert.ToInt32(HttpContext.Request.Query["Qty"].ToString());
UpdateReplacementPrice.Price = Convert.ToDecimal(HttpContext.Request.Query["Price"].ToString());
UpdateReplacementPrice.DryerModel = HttpContext.Request.Query["DryerModel"].ToString();
UpdateReplacementPrice.Voltage = HttpContext.Request.Query["Voltage"].ToString();
UpdateReplacementPrice.EdDrawingItemNo = Convert.ToInt32(HttpContext.Request.Query["EdDrawingItemNo"].ToString());
UpdateReplacementPrice.Currency = HttpContext.Request.Query["Currency"].ToString();
GetReplacementListResponse response = _iAdminReplacementService.SaveReplacementPrice(UpdateReplacementPrice);
return(Ok(response));
}
public GetReplacementListResponse SaveReplacementPrice(UpdateReplacementPrice UpdateReplacementPrice)
{
GetReplacementListResponse response = new GetReplacementListResponse();
TblSshReplacementPartPrice ReplacementPartPrice = new TblSshReplacementPartPrice();
ReplacementPartPrice.Price = UpdateReplacementPrice.Price;
ReplacementPartPrice.PartNo = UpdateReplacementPrice.PartNo;
ReplacementPartPrice.EdDrawingItemNo = UpdateReplacementPrice.EdDrawingItemNo;
ReplacementPartPrice.DryerModel = UpdateReplacementPrice.DryerModel;
ReplacementPartPrice.Currency = UpdateReplacementPrice.Currency;
ReplacementPartPrice.Qty = UpdateReplacementPrice.Qty;
ReplacementPartPrice.Voltage = UpdateReplacementPrice.Voltage;
//var dataKontrol = context.TblSshReplacementPartPriceRepository.Get().Where(q => q.PartNo == Convert.ToInt32(UpdateReplacementPrice.PartNo));
bool kaydedildiMi;
//if (dataKontrol == null)
//{
// kaydedildiMi = context.TblSshReplacementPartPriceRepository.Insert(ReplacementPartPrice);
// context.Save();
//}
//else
//{
// kaydedildiMi = context.TblSshReplacementPartPriceRepository.Update(ReplacementPartPrice);
// context.Save();
//}
kaydedildiMi = context.TblSshReplacementPartPriceRepository.Insert(ReplacementPartPrice);
context.Save();
if (kaydedildiMi == false)
{
response.isSuccess = false;
response.ErrorMessage = "Hata oluştu!!";
return(response);
}
return(response);
}
public GetReplacementListResponse GetReplacementList(SearchPartNo searchPartNo)
{
GetReplacementListResponse response = new GetReplacementListResponse();
List <AdminReplacementPartView> replacementPartData = new List <AdminReplacementPartView>();
var replacementList = from replacementPart in context.TblSshReplacementPartRepository.Get()
join replacementPartPrice in context.TblSshReplacementPartPriceRepository.Get()
on replacementPart.PartNo equals replacementPartPrice.PartNo into replacementPartAndReplacementPartPrice
from replacementPartPrice in replacementPartAndReplacementPartPrice.DefaultIfEmpty()
select new
{
replacementPart.ReplacementPartId,
replacementPart.Sad,
replacementPart.PartNo,
replacementPartPrice.ReplacementPartPriceId,
replacementPartPrice.DryerModel,
replacementPartPrice.EdDrawingItemNo,
replacementPartPrice.Currency,
replacementPartPrice.Price,
replacementPartPrice.Qty,
replacementPartPrice.Voltage
} into selection
select selection;
//if (searchPartNo.partNo == null)
//{
// var replacementList = from replacementPart in context.TblSshReplacementPartRepository.Get()
// join replacementPartPrice in context.TblSshReplacementPartPriceRepository.Get()
// on replacementPart.PartNo equals replacementPartPrice.PartNo into replacementPartAndReplacementPartPrice
// from replacementPartPrice in replacementPartAndReplacementPartPrice.DefaultIfEmpty()
// select new
// {
// replacementPart.ReplacementPartId,
// replacementPart.Sad,
// replacementPart.PartNo,
// replacementPartPrice.ReplacementPartPriceId,
// replacementPartPrice.DryerModel,
// replacementPartPrice.EdDrawingItemNo,
// replacementPartPrice.Currency,
// replacementPartPrice.Price,
// replacementPartPrice.Qty,
// replacementPartPrice.Voltage
// } into selection
// select selection;
//}
//else
//{
// var replacementList = from replacementPart in context.TblSshReplacementPartRepository.Get()
// join replacementPartPrice in context.TblSshReplacementPartPriceRepository.Get()
// on replacementPart.PartNo equals replacementPartPrice.PartNo into replacementPartAndReplacementPartPrice
// from replacementPartPrice in replacementPartAndReplacementPartPrice.DefaultIfEmpty()
// where replacementPart.PartNo == Convert.ToInt32(searchPartNo.partNo)
// select new
// {
// replacementPart.ReplacementPartId,
// replacementPart.Sad,
// replacementPart.PartNo,
// replacementPartPrice.ReplacementPartPriceId,
// replacementPartPrice.DryerModel,
// replacementPartPrice.EdDrawingItemNo,
// replacementPartPrice.Currency,
// replacementPartPrice.Price,
// replacementPartPrice.Qty,
// replacementPartPrice.Voltage
// } into selection
// select selection;
//}
if (replacementList != null)
{
foreach (var item in replacementList)
{
AdminReplacementPartView data = new AdminReplacementPartView();
data.ReplacementPartId = item.ReplacementPartId;
data.Sad = item.Sad;
data.PartNo = item.PartNo;
data.ReplacementPartPriceId = item.ReplacementPartPriceId;
data.DryerModel = item.DryerModel;
data.EdDrawingItemNo = item.EdDrawingItemNo;
data.Currency = item.Currency;
data.Price = item.Price;
data.Qty = item.Qty;
data.Voltage = item.Voltage;
replacementPartData.Add(data);
}
response.isSuccess = true;
response.ReplacementList = replacementPartData;
}
else
{
response.isSuccess = false;
}
return(response);
}
