private int DeleteTblBank(TblBank row, int index, string company)
{
using (var entity = new ccnewEntities(GetSqlConnectionString(company)))
{
var query = (from e in entity.TblBanks
where e.Iserial == row.Iserial
select e).SingleOrDefault();
if (query != null)
{
var Ledger = entity.TblLedgerMainDetails.Where(w => w.EntityAccount == query.Iserial);
if (Ledger.Any())
{
throw new System.Exception("Cannot delete Because There is a transaction Exisit");
}
entity.DeleteObject(query);
}
entity.SaveChanges();
}
return(row.Iserial);
}
public void SaveOldRow(TblBankViewModel oldRow)
{
if (oldRow != null)
{
var valiationCollection = new List <ValidationResult>();
var isvalid = Validator.TryValidateObject(oldRow,
new ValidationContext(oldRow, null, null), valiationCollection, true);
if (isvalid)
{
var save = oldRow.Iserial == 0;
if (AllowUpdate != true && !save)
{
MessageBox.Show(strings.AllowUpdateMsg);
return;
}
var saveRow = new TblBank();
saveRow.InjectFrom(oldRow);
if (!Loading)
{
Loading = true;
Glclient.UpdateOrInsertTblBanksAsync(saveRow, save, MainRowList.IndexOf(oldRow),
LoggedUserInfo.DatabasEname);
}
}
}
}
public async Task <ActionResult <TblBank> > PostTblBank(TblBank tblBank)
{
_context.TblBank.Add(tblBank);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetTblBank", new { id = tblBank.Id }, tblBank));
}
public async Task <IActionResult> PutTblBank(long id, TblBank tblBank)
{
if (id != tblBank.Id)
{
return(BadRequest());
}
_context.Entry(tblBank).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TblBankExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ApiResponse> DeleteBank(TblBank tblBank)
{
// var _tblBank = await _context.TblBank.FindAsync(tblBank.Id);
if (tblBank == null)
{
var ApiResponseErr = await response.ApiResult("FAILED", "", "Bank Not Found");
return(ApiResponseErr);
}
_context.Entry(tblBank).Property(x => x.DeleteDate).IsModified = true;
try
{
var respose = await _context.SaveChangesAsync();
var responsebank = await GetAllBanks();
return(responsebank);
}
catch (DbUpdateConcurrencyException ex)
{
var ApiResponse = await response.ApiResult("FAILED", ex, "Bank Not Found");
return(ApiResponse);
}
}
public async Task <ApiResponse> EnableDisableBank(TblBank tblBank)
{
TblBank _tblbank = new TblBank
{
Id = tblBank.Id,
ForJtc = tblBank.ForJtc
};
_context.Entry(_tblbank).Property(x => x.ForJtc).IsModified = true;
try
{
var respose = await _context.SaveChangesAsync();
var responsebank = await GetAllBanks();
return(responsebank);
}
catch (DbUpdateConcurrencyException ex)
{
if (!TblBankExists(tblBank.Id))
{
var ApiResponse = await response.ApiResult("FAILED", "", "Bank Not Found");
return(ApiResponse);
}
else
{
var ApiResponse = await response.ApiResult("FAILED", ex, "Bank Not Found");
return(ApiResponse);
}
}
}
public async Task <ApiResponse> AddBank(TblBank tblBank)
{
_context.TblBank.Add(tblBank);
await _context.SaveChangesAsync();
var response = await GetAllBanks();
return(response);
}
public async Task <ApiResponse> BankById(TblBank tblBank)
{
var tblBankresponse = await _context.TblBank.FindAsync(tblBank.Id);
if (tblBank == null)
{
var ApiResponseErr = await response.ApiResult("FAILED", "", "Bank Not Found");
return(ApiResponseErr);
}
var ApiResponse = await response.ApiResult("OK", tblBankresponse, "Bank Found");
return(ApiResponse);
}
public async Task <ApiResponse> UpdateBank(TblBank tblBank)
{
_context.Entry(tblBank).State = EntityState.Modified;
_context.Entry(tblBank).Property(x => x.RecordDate).IsModified = false;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
var ApiResponse = await response.ApiResult("FAILED", "", "Bank Not Found");
return(ApiResponse);
}
var responseBank = await GetAllBanks();
return(responseBank);
}
private TblBank UpdateOrInsertTblBanks(TblBank newRow, bool save, int index, out int outindex, string company)
{
outindex = index;
using (var entity = new ccnewEntities(GetSqlConnectionString(company)))
{
if (save)
{
entity.TblBanks.AddObject(newRow);
}
else
{
var oldRow = (from e in entity.TblBanks
where e.Iserial == newRow.Iserial
select e).SingleOrDefault();
if (oldRow != null)
{
GenericUpdate(oldRow, newRow, entity);
}
}
entity.SaveChanges();
return(newRow);
}
}
