public async Task <IActionResult> AddEditPaymentDetails(int id, [Bind("Amount, InvoiceNumber, CardEndingNumber, CardType, EDCId, EDCTranscationId, OnDate, StoreId")] EDCTranscation eDC)
{
if (ModelState.IsValid)
{
//Insert
if (eDC.EDCTranscationId == 0)
{
db.Add(eDC);
await db.SaveChangesAsync();
}
//Update
else
{
try
{
db.Update(eDC);
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CardTranscationExists(eDC.EDCTranscationId))
{
return(NotFound());
}
else
{
throw;
}
}
}
return(Json(new { isValid = true, html = Helper.RenderRazorViewToString(this, "Index", db.CardTranscations.ToList()) }));
}
return(Json(new { isValid = false, html = Helper.RenderRazorViewToString(this, "AddEditPaymentDetails", eDC) }));
//TODO: here we need to refresh index page update/add opertation if required other wise no need call this function just pass is valid or not.
}
public async Task <IActionResult> PutEDCTranscation(int id, EDCTranscation eDCTranscation)
{
if (id != eDCTranscation.EDCTranscationId)
{
return(BadRequest());
}
_context.Entry(eDCTranscation).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!EDCTranscationExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <EDCTranscation> > PostEDCTranscation(EDCTranscation eDCTranscation)
{
_context.CardTranscations.Add(eDCTranscation);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetEDCTranscation", new { id = eDCTranscation.EDCTranscationId }, eDCTranscation));
}
private async System.Threading.Tasks.Task <int> AddEDCTranscationAsync()
{
//EDCTranscationId EDCId Amount OnDate CardEndingNumber CardTypes InvoiceNumber StoreId
var ws = xS.GetWS("CardTranscations");
var nonEmptyDataRows = ws.RowsUsed();
int Row = 6;//Title;
List <EDCTranscation> cardM = new List <EDCTranscation>();
foreach (var dR in nonEmptyDataRows)
{
if (dR.RowNumber() > Row)
{
EDCTranscation eDC = new EDCTranscation
{
EDCTranscationId = dR.Cell(1).GetValue <int>(),
EDCId = dR.Cell(2).GetValue <int>(),
Amount = dR.Cell(3).GetValue <decimal>(),
OnDate = dR.Cell(4).GetDateTime(),
CardEndingNumber = dR.Cell(5).Value.ToString(),
CardTypes = dR.Cell(6).GetValue <CardMode>(),
InvoiceNumber = dR.Cell(7).Value.ToString(),
StoreId = dR.Cell(8).GetValue <int>(),
IsReadOnly = true,
UserId = "Admin"
};
}
}
//Add Here
await db.CardTranscations.AddRangeAsync(cardM);
return(await db.SaveChangesAsync());
}
