public int AddClientDetails(ClientDetail Objclient)
{
//Insert User details
int Result = 0;
try
{
var model = new LegaSys_ClientDetails
{
ClientDetailID = Objclient.ClientDetailID,
ClientName = Objclient.ClientName,
Address = Objclient.Address,
Country = Objclient.Country,
CoClient = Objclient.CoClient,
CoClient2 = Objclient.CoClient2,
CoClient3 = Objclient.CoClient3,
CoClient4 = Objclient.CoClient4,
EmailID = Objclient.EmailID,
EmailID2 = Objclient.EmailID2,
EmailID3 = Objclient.EmailID3,
EmailID4 = Objclient.EmailID4,
Created_By = Objclient.Created_By,
Updated_By = Objclient.Updated_By,
Created_Date = System.DateTime.UtcNow,
Updated_Date = System.DateTime.UtcNow,
IsActive = true
};
db.LegaSys_ClientDetails.Add(model);
db.SaveChanges();
return(Result = model.ClientDetailID);
}
catch (Exception)
{
Result = 0;
}
return(Result);
}
//Delete client
public string DeleteClientById(Int32 Id)
{
string Result = string.Empty;
LegaSys_ClientDetails obj = new LegaSys_ClientDetails();
try
{
var ClientDetail = db.LegaSys_ClientDetails.Where(p => p.ClientDetailID == Id).FirstOrDefault();
if (ClientDetail != null)
{
obj.ClientDetailID = ClientDetail.ClientDetailID;
obj.ClientName = ClientDetail.ClientName;
obj.Address = ClientDetail.Address;
obj.Country = ClientDetail.Country;
obj.CoClient = ClientDetail.CoClient;
obj.CoClient2 = ClientDetail.CoClient2;
obj.CoClient3 = ClientDetail.CoClient3;
obj.CoClient4 = ClientDetail.CoClient4;
obj.EmailID = ClientDetail.EmailID;
obj.EmailID2 = ClientDetail.EmailID2;
obj.EmailID3 = ClientDetail.EmailID3;
obj.EmailID4 = ClientDetail.EmailID4;
obj.Created_By = ClientDetail.Created_By;
obj.Updated_By = 1;
obj.Created_Date = System.DateTime.UtcNow;
obj.Updated_Date = System.DateTime.UtcNow;
obj.IsActive = false;
db.LegaSys_ClientDetails.AddOrUpdate(obj);
db.SaveChanges();
Result = "Data updated successfully!";
}
}
catch (Exception)
{
throw;
}
return(Result);
}
//Update client details
public string UpdateClientDetails(ClientDetail objClient)
{
//declare the object to return
string Result = string.Empty;
LegaSys_ClientDetails obj = new LegaSys_ClientDetails();
try
{
obj.ClientDetailID = objClient.ClientDetailID;
obj.ClientName = objClient.ClientName;
obj.Address = objClient.Address;
obj.Country = objClient.Country;
obj.CoClient = objClient.CoClient;
obj.CoClient2 = objClient.CoClient2;
obj.CoClient3 = objClient.CoClient3;
obj.CoClient4 = objClient.CoClient4;
obj.EmailID = objClient.EmailID;
obj.EmailID2 = objClient.EmailID2;
obj.EmailID3 = objClient.EmailID3;
obj.EmailID4 = objClient.EmailID4;
obj.Created_By = objClient.Created_By;
obj.Updated_By = objClient.Updated_By;
obj.Created_Date = System.DateTime.UtcNow;
obj.Updated_Date = System.DateTime.UtcNow;
obj.IsActive = true;
db.LegaSys_ClientDetails.AddOrUpdate(obj);
db.SaveChanges();
Result = "Data updated successfully!";
}
catch (Exception)
{
Result = "Some technical error!";
throw;
}
return(Result);
}
