//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; } } }