public async Task <Metadata> Delete(long RoleID)
{
Metadata res = new Metadata();
try
{
var dataRoles = await context.Roles.FirstOrDefaultAsync(x => x.roleid == RoleID);
if (dataRoles == null)
{
return new Metadata()
{
status = false, data = "Data not found"
}
}
;
context.RoleScreen.RemoveRange(context.RoleScreen.Where(x => x.roleid == RoleID));
context.Remove(dataRoles);
await context.SaveChangesAsync();
res.status = true;
res.data = "Data was successfully deleted";
}
catch (Exception ex)
{
res.status = false;
res.data = ex.Message;
}
return(res);
}
public async Task <Metadata> Delete(long ResidentID)
{
Metadata res = new Metadata();
try
{
var resident = (from r in context.Resident where r.residentid == ResidentID select r).FirstOrDefault();
if (resident == null)
{
return(new Metadata()
{
data = "Resident not found", status = false
});
}
context.Resident.Remove(resident);
await context.SaveChangesAsync();
res.status = true;
res.data = "Data Deleted";
}
catch (Exception e)
{
res.data = e.Message.ToString();
}
return(res);
}
public async Task <Metadata> Delete(long CustomerID)
{
Metadata res = new Metadata();
try
{
var Customer = (from r in context.Customer where r.customerid == CustomerID select r).FirstOrDefault();
if (Customer == null)
{
return(new Metadata()
{
data = "Customer not found", status = false
});
}
context.Customer.Remove(Customer);
await context.SaveChangesAsync();
res.status = true; res.data = "Data Deleted";
}
catch (Exception e)
{
res.data = e.Message.ToString();
}
return(res);
}
public async Task <Metadata> Insert(UserViewModel model)
{
Metadata res = new Metadata();
try
{
var dataUSer = await context.Users.AnyAsync(x => x.username.ToLower().Replace(" ", "") == model.UserName.ToLower().Replace(" ", "") && x.userid != model.UserID);
if (dataUSer)
{
return new Metadata()
{
status = false, data = "User name is ready"
}
}
;
string saltNow = GenerateSalt();
await context.Users.AddAsync(new UserModel()
{
email = model.Email,
username = model.UserName,
salt = saltNow,
password = HashedPassword(model.Password, saltNow),
roleid = model.RoleID
});
await context.SaveChangesAsync();
res.status = true;
res.data = "Data was successfully inserted";
}
catch (Exception ex)
{
res.status = false;
res.data = ex.Message;
}
return(res);
}
public async Task <Metadata> update(RoleScreenViewModel model)
{
Metadata res = new Metadata();
if (model.RoleID == 0 || model.Screens == null || model.Screens.Count == 0)
{
return(new Metadata()
{
data = "Application not allowed"
});
}
;
try
{
_context.RoleScreen.RemoveRange(_context.RoleScreen.Where(x => x.roleid == model.RoleID));
List <RoleScreenModel> lsModel = new List <RoleScreenModel>();
model.Screens.ForEach(rolescreen =>
{
lsModel.Add(new RoleScreenModel()
{
roleid = model.RoleID,
screenid = rolescreen.ScreenID,
deleteflag = rolescreen.DeleteFlag,
readflag = rolescreen.ReadFlag,
writeflag = rolescreen.WriteFlag
});
});
_context.RoleScreen.AddRange(lsModel);
int affect = await _context.SaveChangesAsync();
res.status = true;
}
catch (Exception e)
{
res.data = e.Message.ToString();
}
return(res);
}
public async Task <Metadata> SaveTransactionAsync(TransactionViewModel model)
{
Metadata res = new Metadata();
await context.Database.BeginTransactionAsync();
try
{
var txn = await context.Trx.Where(x => x.trxdate.Date == model.TrxDate.Date).FirstOrDefaultAsync();
if (txn == null)
{
txn = new TransactionModel();
txn.createdby = model.CreatedBy;
txn.createddate = model.CreatedDate;
txn.total = 0;
txn.trxdate = model.TrxDate.Date;
await context.Trx.AddAsync(txn);
}
else
{
txn.updatedby = model.CreatedBy;
txn.updateddate = model.CreatedDate;
txn.total = 0;
context.Trx.Update(txn);
}
await context.SaveChangesAsync();
var itemTxn = context.TrxItem.Where(x => x.trxid == txn.trxid);
foreach (var item in model.listItemTrx)
{
if (item.TrxItemID != null && itemTxn.Any(x => x.trxitemid == item.TrxItemID))
{
var itemTxnDetail = itemTxn.Where(x => x.trxitemid == item.TrxItemID).FirstOrDefault();
itemTxnDetail.afteramount = (decimal)item.AfterAmount;
itemTxnDetail.beforeamount = (decimal)item.BeforeAmount;
itemTxnDetail.qty = (decimal)item.Qty;
context.TrxItem.Update(itemTxnDetail);
}
else
{
var modelTxnItem = new TrxItemModel()
{
afteramount = (decimal)item.AfterAmount,
beforeamount = (decimal)item.BeforeAmount,
qty = (decimal)item.Qty,
price = (decimal)item.Price,
trxid = txn.trxid,
customerid = (long)item.CustomerID,
isclear = false,
residentid = (long)item.ResidentID
};
await context.TrxItem.AddAsync(modelTxnItem);
}
}
await context.SaveChangesAsync();
await context.Database.CommitTransactionAsync();
res.status = true;
}
catch (Exception ex)
{
await context.Database.RollbackTransactionAsync();
res.data = ex.Message;
}
return(res);
}