public async Task <IActionResult> delete(discountSetupLineList discSetupLnList)
{
try
{
List <DiscountSetupLines> list = discSetupLnList.discountLines;
for (int i = 0; i < list.Count; i++)
{
var discSetup = _context.DiscountSetup.Where(x => x.DiscountCode == list[i].DiscountSetup.DiscountCode).First();
var discSetupLnObj = _context.DiscountSetupLines.Where(x => x.DiscountSetupId == discSetup.Id && x.Code == list[i].Code).First();
_context.DiscountSetupLines.Remove(discSetupLnObj);
_context.SaveChanges();
}
return(StatusCode(200, new
{
status = "200",
delete = true,
message = "Deleted successfully!"
}));
}
catch (Exception ex)
{
return(StatusCode(500, new
{
status = "500",
delete = false,
message = ex.ToString()
}));
}
}
public async Task <IActionResult> update(discountSetupLineList discSetupLnList)
{
try
{
List <DiscountSetupLines> list = discSetupLnList.discountLines;
for (int i = 0; i < list.Count; i++)
{
//var discSetup = _context.DiscountSetup.Where(x => x.DiscountCode == list[i].DiscountSetup.DiscountCode).First();
bool discExist = false;
discExist = _context.DiscountSetupLines.Any(c => c.Id == list[i].Id);
if (discExist == true)
{
var discSetupLnObj = _context.DiscountSetupLines.Where(x => x.Id == list[i].Id).First();
discSetupLnObj.GroupCode = list[i].GroupCode;
discSetupLnObj.Code = list[i].Code;
discSetupLnObj.DiscountCash = list[i].DiscountCash;
discSetupLnObj.DiscountPrecentage = list[i].DiscountPrecentage;
discSetupLnObj.AmountMin = list[i].AmountMin;
discSetupLnObj.AmountMax = list[i].AmountMax;
discSetupLnObj.QtyMin = list[i].QtyMin;
discSetupLnObj.QtyMax = list[i].QtyMax;
discSetupLnObj.Multi = list[i].Multi;
discSetupLnObj.StartDate = list[i].StartDate;
discSetupLnObj.EndDate = list[i].EndDate;
_context.DiscountSetupLines.Update(discSetupLnObj);
_context.SaveChanges();
}
else
{
return(StatusCode(404, new
{
status = "404",
update = false,
message = "Record not found."
}));
}
}
return(StatusCode(200, new
{
status = "200",
update = true,
message = "updated successfully!"
}));
}
catch (Exception ex)
{
return(StatusCode(500, new
{
status = "500",
update = false,
message = ex.ToString()
}));
}
}
public async Task <IActionResult> create(discountSetupLineList discSetupLnList)
{
try
{
List <DiscountSetupLines> list = discSetupLnList.discountLines;
for (int i = 0; i < list.Count; i++)
{
var discSetup = _context.DiscountSetup.Where(x => x.DiscountCode == list[i].DiscountCode).First();
DiscountSetupLines discSetupLines = new DiscountSetupLines();
discSetupLines.DiscountCode = list[i].DiscountCode;
discSetupLines.GroupCode = list[i].GroupCode;
discSetupLines.Code = list[i].Code;
discSetupLines.DiscountPrecentage = list[i].DiscountPrecentage;
discSetupLines.DiscountCash = list[i].DiscountCash;
discSetupLines.QtyMin = list[i].QtyMin;
discSetupLines.QtyMax = list[i].QtyMax;
discSetupLines.AmountMin = list[i].AmountMin;
discSetupLines.AmountMax = list[i].AmountMax;
discSetupLines.ArticleIdDiscount = list[i].ArticleIdDiscount;
discSetupLines.Multi = list[i].Multi;
discSetupLines.DiscountSetupId = discSetup.Id;
discSetupLines.CreatedDate = DateTime.Now;
_context.Add(discSetupLines);
_context.SaveChanges();
}
return(StatusCode(200, new
{
status = "200",
create = true,
message = "created successfully!"
}));
}
catch (Exception ex)
{
return(StatusCode(500, new
{
status = "500",
create = false,
message = ex.ToString()
}));
}
}