public void DeleteClient(tbl_Clients tblClient)
{
try
{
IGenericDataRepository <tbl_Clients> repository = new GenericDataRepository <tbl_Clients>();
repository.Remove(tblClient);
}
catch (Exception)
{
throw;
}
}
public tbl_Clients FindClientName(string clientName)
{
try
{
IGenericDataRepository <tbl_Clients> repository = new GenericDataRepository <tbl_Clients>();
tbl_Clients tblclientName = repository.GetSingle(c => c.ClientName.ToUpper() == clientName.ToUpper());
return(tblclientName);
}
catch (Exception)
{
throw;
}
}
public tbl_Clients FindClient(int?clientID)
{
try
{
IGenericDataRepository <tbl_Clients> repository = new GenericDataRepository <tbl_Clients>();
tbl_Clients client = repository.GetSingle(c => c.ClientID == clientID);
return(client);
}
catch (Exception)
{
throw;
}
}
public void AddClient(tbl_Clients tblClient)
{
try
{
IGenericDataRepository <tbl_Clients> repository = new GenericDataRepository <tbl_Clients>();
repository.Add(tblClient);
}
catch (Exception)
{
throw;
}
}
// GET: Common
public string GetClientName(int clientId)
{
try
{
tbl_Clients tblClient = new tbl_Clients();
ClientManager clientManager = new ClientManager();
tblClient = clientManager.FindClient(clientId);
return(tblClient.ClientName);
}
catch (Exception)
{
throw;
}
}
public void UpdateClient(ClientViewModel clientViewModel)
{
try
{
tbl_Clients tblClient = new tbl_Clients();
tblClient.ClientID = clientViewModel.ClientID;
tblClient.ClientName = clientViewModel.ClientName;
tblClient.EntityState = DA.DomainModel.EntityState.Modified;
ClientManager clientManager = new ClientManager();
clientManager.UpdateClient(tblClient);
}
catch (Exception)
{
throw;
}
}
public bool DeleteClient(ClientViewModel clientViewModel)
{
try
{
tbl_Clients tblClient = new tbl_Clients();
tblClient.ClientID = clientViewModel.ClientID;
tblClient.EntityState = DA.DomainModel.EntityState.Deleted;
ClientManager clientManager = new ClientManager();
clientManager.DeleteClient(tblClient);
}
catch (Exception)
{
throw;
}
return(true);
}
public int AddClient(ClientsModel model)
{
using (var context = new TravelAgencyEntities())
{
tbl_Clients clients = new tbl_Clients()
{
FirstName = model.FirstName,
LastName = model.LastName,
Username = model.EmailId,
EmailId = model.EmailId,
MobileNo = model.MobileNo,
Address = model.Address,
City = model.City,
State = model.State,
Password = model.Password
};
context.tbl_Clients.Add(clients);
context.SaveChanges();
return(clients.Id);
}
}
