//save using a 'Client' type variable
public bool SaveClient(ErrorLogDataAccess.DataClasses.Client ClientObj, int userId = 1)
{
using (TransactionScope scope1 = new TransactionScope())
{
try
{
string formattedDate = DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss tt", CultureInfo.InvariantCulture);
var ClientCollection = mongoDatabaseRunTime.GetCollection <ErrorLogDataAccess.DataClasses.Client>("Client");
var ClientRow = new ErrorLogDataAccess.DataClasses.Client()
{
ClientId = GetNewClientID(),
ClientCode = ClientObj.ClientCode,
ClientName = ClientObj.ClientName,
ClientDescription = ClientObj.ClientDescription,
IsActive = ClientObj.IsActive,
EntryDate = formattedDate
};
ClientCollection.InsertOne(ClientRow);
scope1.Complete();
return(true);
}
catch (Exception)
{
scope1.Dispose();
throw;
}
}
}
public bool UpdateClient(ErrorLogDataAccess.DataClasses.Client ClientObj)
{
using (TransactionScope scope1 = new TransactionScope())
{
try
{
string formattedDate = DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss tt", CultureInfo.InvariantCulture);
var ClientCollection = mongoDatabaseRunTime.GetCollection <ErrorLogDataAccess.DataClasses.Client>("Client");
var filterObj = Builders <ErrorLogDataAccess.DataClasses.Client> .Filter.Eq("ClientCode", ClientObj.ClientCode);
var updateObj = Builders <ErrorLogDataAccess.DataClasses.Client> .Update
.Set("ClientName", ClientObj.ClientName)
.Set("ClientDescription", ClientObj.ClientDescription)
.Set("IsActive", ClientObj.IsActive)
.Set("LastUpdatedDate", formattedDate)
.CurrentDate("lastModified");
ClientCollection.UpdateOne(filterObj, updateObj);
scope1.Complete();
return(true);
}
catch (Exception ex)
{
scope1.Dispose();
throw;
}
}
}
