public int DeleteClient(int key)
{
TblClients client = dbContext.TblClients.Where(x => x.ClientId == key).FirstOrDefault();
client.IsActive = false;
dbContext.TblClients.Update(client);
return(dbContext.SaveChanges());
}
public int UpdateClient(TblClients client)
{
if (dbContext.TblClients.Where(r => r.ClientName.ToUpper() == client.ClientName.ToUpper() && r.ClientId != client.ClientId && r.IsActive == true).Count() > 0)
{
return(-1);
}
client.IsActive = true;
client.ModifiedBy = CurrentContext.EmployeeID;
client.ModifiedDate = System.DateTime.Now;
dbContext.Entry(client).State = EntityState.Modified;
dbContext.TblClients.Update(client);
int result = dbContext.SaveChanges();
dbContext.Entry(client).State = EntityState.Detached;
return(result);
}
public int UpdateClient(TblClients client)
{
return(MastersDAL.UpdateClient(client));
}
//public List<TblCountries> GetCountries()
//{
// return MastersDAL.GetCountries();
//}
//public List<TblStates> GetStates()
//{
// return MastersDAL.GetStates();
//}
//public List<TblCities> GetCities()
//{
// return MastersDAL.GetCities();
//}
#endregion
#region Clients
public int CreateClient(TblClients client)
{
return(MastersDAL.CreateClient(client));
}
public IActionResult UpdateClients(int id, [FromBody] TblClients client)
{
int result = _imasters.UpdateClient(client);
return(Ok(result));
}
public IActionResult Clients([FromBody] TblClients client)
{
int result = _imasters.CreateClient(client);
return(Ok(result));
}
public IActionResult Clients(int id)
{
TblClients result = _imasters.GetClientByCriteria(id);
return(Ok(result));
}
