private string SubmitDbChanges() { try { DataContext.SubmitChanges(); } catch (Exception e) { return(e.Message); } return(string.Empty); }
public string AssignUrlToRole(int roleId, int urlId) { var newMarsUserUserRole = new MarsUserRoleMenuAccess { MarsUserRoleId = roleId, UrlId = urlId }; DataContext.MarsUserRoleMenuAccesses.InsertOnSubmit(newMarsUserUserRole); DataContext.SubmitChanges(); return(string.Empty); }
public static void LogUserLogon(string userName, string userId, DateTime loggedOnAt) { using (var dataContext = new MarsDBDataContext(MarsConnection.ConnectionString)) { var userLogonEntry = new UserLogonHistory { TimeStamp = loggedOnAt, UserName = userName, UserId = userId }; dataContext.UserLogonHistories.InsertOnSubmit(userLogonEntry); dataContext.SubmitChanges(); } }
public void SetCmd(string descriptor, string command) { if (String.IsNullOrEmpty(command)) { return; } using (MarsDBDataContext db = new MarsDBDataContext()) { ManualMovementXCmd mmxc = (from p in db.ManualMovementXCmds where p.Descriptor == descriptor select p).First(); mmxc.Command = command; db.SubmitChanges(); } }
public static void LogPageAccess(string userId, string url, string userName) { using (var dataContext = new MarsDBDataContext(MarsConnection.ConnectionString)) { var spa = new StatisticsPageAccess() { AccessedBy = userId, AccessedOn = DateTime.Now, Url = url, UserName = userName }; dataContext.StatisticsPageAccesses.InsertOnSubmit(spa); dataContext.SubmitChanges(); } }
public void UpdateFleetOwner(FleetOwnerEntity foe) { var dbFleetOwner = DataContext.FleetOwners.Single(d => d.FleetOwnerId == foe.FleetOwnerId); if (foe.CompanyId == -1) { dbFleetOwner.Company = null; } else { dbFleetOwner.CompanyId = foe.CompanyId; } dbFleetOwner.OwnerName = foe.FleetOwnerName; DataContext.SubmitChanges(); }
private string SubmitDbChanges() { try { DataContext.SubmitChanges(); } catch (SqlException e) { if (e.ErrorCode == -2146232060) { return(ForeignKeyError); } return(e.Message); } return(string.Empty); }
public void SetMessage(string message, FleetPlanOptions Status) { using (MarsDBDataContext db = new MarsDBDataContext()) { Log mlv = new Log { DateTime = DateTime.Now, Message = message, Status_Id = (Int32?)Status, LogType_Id = LOGTYPE // Fleetsize }; db.Logs.InsertOnSubmit(mlv); try { db.SubmitChanges(); } catch (Exception e) { //ILog l = log4net.LogManager.GetLogger(LOGNAME); //if (l!=null) l.Error(EXCEPTIONMESSAGE + e.Message); } } }
public static void SaveNews(string userId, string heading, string details, bool Active, bool Priority) { using (var dataContext = new MarsDBDataContext(MarsConnection.ConnectionString)) { var spa = new Communication { UpdatedBy = userId, CommDate = DateTime.Now, Heading = heading, Details = details, IsActive = Active, Priority = Priority }; dataContext.Communications.InsertOnSubmit(spa); dataContext.SubmitChanges(); } }
public void saveRemark(string license, string remark) { // adds a comment to the VehiclesAbroadComments table using (MarsDBDataContext db = new MarsDBDataContext()) { var q = (from p in db.VehiclesAbroadComments where p.License == license select p).FirstOrDefault(); if (q == null) { VehiclesAbroadComment vac = new VehiclesAbroadComment { License = license, Comment = remark, UpdateDate = DateTime.Now }; db.VehiclesAbroadComments.InsertOnSubmit(vac); } else { q.Comment = remark; q.UpdateDate = DateTime.Now; } db.SubmitChanges(); } }
public static void UpdateNews(int commsID, string userId, string heading, string details, bool Active, bool Priority) { using (var dataContext = new MarsDBDataContext(MarsConnection.ConnectionString)) { var commEntry = dataContext.Communications.FirstOrDefault(d => d.CommunicationsID == commsID); if (commEntry == null) { throw new Exception("Invalid primary key passed to Update News"); } commEntry.CommunicationsID = commsID; commEntry.CommDate = DateTime.Now; commEntry.UpdatedBy = userId; commEntry.Heading = heading; commEntry.Details = details; commEntry.IsActive = Active; commEntry.Priority = Priority; dataContext.SubmitChanges(); } }
public static void DeleteNewsItem(int commsID) { using (var dataContext = new MarsDBDataContext(MarsConnection.ConnectionString)) { var deleteDetails = from details in dataContext.Communications where details.CommunicationsID == commsID select details; foreach (var detail in deleteDetails) { dataContext.Communications.DeleteOnSubmit(detail); } try { dataContext.SubmitChanges(); } catch { throw new Exception("Invalid primary key passed to Delete News"); } } }
public void Submit() { //_dataContext.Log = new DebugTextWriter(); _dataContext.SubmitChanges(); }