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();
}