public static int Update(tblCompany companyObj)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
tblCompany originCompany = db.tblCompanies.Where(g => g.CompanyCode == companyObj.CompanyCode).FirstOrDefault();
if (originCompany == null)
{
return(-1);
}
originCompany.CompanyName = companyObj.CompanyName;
originCompany.Description = companyObj.Description;
originCompany.ModifiedBy = companyObj.ModifiedBy;
originCompany.ModifiedDate = CommonFactory.GetCurrentDate();
try
{
return(db.SaveChanges());
}
catch (Exception ex)
{
return(-1);
}
}
public static int Delete(Int64 ID)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
try
{
var reply = db.tblListHandoverReplies.FirstOrDefault(vt => vt.ID == ID);
if (reply == null)
{
return(0);
}
else
{
//update all related Handover
RemoveListReplyIDFromHandover(ID);
//delete Bang ke hoi bao
db.DeleteObject(reply);
return(db.SaveChanges());
}
}
catch (Exception ex)
{
return(0);
}
finally
{
db.Dispose();
}
}
public static int Update(tblType typeObj)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
tblType originType = db.tblTypes.Where(g => g.TypeCode == typeObj.TypeCode).FirstOrDefault();
if (originType == null)
{
return(-1);
}
originType.TypeName = typeObj.TypeName;
originType.Description = typeObj.Description;
originType.ModifiedBy = typeObj.ModifiedBy;
originType.ModifiedDate = CommonFactory.GetCurrentDate();
try
{
return(db.SaveChanges());
}
catch (Exception ex)
{
return(-1);
}
}
public static int DeleteGroupByGroupID(int groupID)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
var group = db.tblGroups.Where(g => g.GroupID == groupID).FirstOrDefault();
if (group == null)
{
return(0);
}
//delete group
db.DeleteObject(group);
//delete group's users in tblUserInGroup
List <tblUserInGroup> listTblUserInGroup = db.tblUserInGroups.Where(g => g.GroupID == groupID).ToList();
foreach (tblUserInGroup userInGroup in listTblUserInGroup)
{
db.DeleteObject(userInGroup);
}
//delete group's permission in tblUserGroupPermistion
List <tblUserGroupPermission> listUserGroupPermission = db.tblUserGroupPermissions.Where(g => g.GroupID == groupID && g.PermissionType == UserGroupPermissionFactory.PERMISSION_TYPE_GROUP).ToList();
foreach (tblUserGroupPermission userGroupPermission in listUserGroupPermission)
{
db.DeleteObject(userGroupPermission);
}
int re = db.SaveChanges();
db.Connection.Close();
return(re);
}
public static tblListHandoverReply InsertListHandoverReply(tblListHandoverReply handoverReply, List <tblHandover> listHandover, tblNumberGenerate numberGenerate)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
db.AddTotblNumberGenerates(numberGenerate);
db.AddTotblListHandoverReplies(handoverReply);
foreach (tblHandover handover in listHandover)
{
tblHandover obj = db.tblHandovers.Where(g => g.ID == handover.ID).FirstOrDefault();
if (obj != null)
{
obj.tblListHandoverReply = handoverReply;
}
}
int result = db.SaveChanges();
if (result > 0)
{
return(handoverReply);
}
else
{
return(null);
}
}
public static int Delete(String companyCode)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
var company = db.tblCompanies.FirstOrDefault(vt => vt.CompanyCode == companyCode);
db.DeleteObject(company);
return(db.SaveChanges());
}
public static int Delete(long trainId)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
var train = db.tblTrains.FirstOrDefault(g => g.TrainID == trainId);
db.DeleteObject(train);
return(db.SaveChanges());
}
public static int AddNew(tblNumberGenerate number)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
db.AddTotblNumberGenerates(number);
return(db.SaveChanges());
}
public static int Insert(tblTrain train)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
train.CreatedDate = CommonFactory.GetCurrentDate();
db.AddTotblTrains(train);
return(db.SaveChanges());
}
public static int Insert(tblCompany company)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
company.CreatedDate = CommonFactory.GetCurrentDate();
company.ModifiedDate = CommonFactory.GetCurrentDate();
db.AddTotblCompanies(company);
return(db.SaveChanges());
}
public static int DeleteType(String typeCode)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
var type = db.tblTypes.FirstOrDefault(vt => vt.TypeCode == typeCode);
db.DeleteObject(type);
return(db.SaveChanges());
}
public static int Delete(String customsCode)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
var customs = db.tblCustoms.FirstOrDefault(g => g.CustomsCode == customsCode);
db.DeleteObject(customs);
return(db.SaveChanges());
}
public static int Insert(tblUserInGroup userGroup)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
db.AddTotblUserInGroups(userGroup);
int re = db.SaveChanges();
db.Connection.Close();
return(re);
}
public static int InsertToKhai(tblToKhaiTau tokhai)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
tokhai.CreatedDate = CommonFactory.GetCurrentDate();
db.AddTotblToKhaiTaus(tokhai);
return(db.SaveChanges());
}
/// <summary>
/// Insert User
/// </summary>
/// <param name="userInfo">UserInfo object</param>
/// <returns>Number of rows are effected</returns>
public static int Insert(tblUser userInfo)
{
// Encode password & username
userInfo.Password = Common.Encode(userInfo.Password);
var db = new dbTrainEntities(ConnectionController.GetConnection());
db.AddTotblUsers(userInfo);
var re = db.SaveChanges();
return(re);
}
public static int Insert(tblGroup group)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
group.CreatedDate = CommonFactory.GetCurrentDate();
group.ModifiedDate = CommonFactory.GetCurrentDate();
db.AddTotblGroups(group);
int re = db.SaveChanges();
db.Connection.Close();
return(re);
}
public static int InsertToaTau(List <tblToaTau> listToaTau)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
foreach (var toaTau in listToaTau)
{
toaTau.CreatedDate = CommonFactory.GetCurrentDate();
db.AddTotblToaTaus(toaTau);
}
return(db.SaveChanges());
}
public static int Insert(List <tblUserGroupPermission> listUserGroupPermission)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
foreach (tblUserGroupPermission userGroupPermission in listUserGroupPermission)
{
db.AddTotblUserGroupPermissions(userGroupPermission);
}
int re = db.SaveChanges();
db.Connection.Close();
return(re);
}
public static int DeleteUserInGroup(int groupID, int userID)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
tblUserInGroup tblUserInGroup = db.tblUserInGroups.Where(g => g.GroupID == groupID && g.UserID == userID).FirstOrDefault();
if (tblUserInGroup != null)
{
db.DeleteObject(tblUserInGroup);
}
int re = db.SaveChanges();
db.Connection.Close();
return(re);
}
public static int DeleteUserInGroupByGroupID(Int32 groupID)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
List <tblUserInGroup> listTblUserInGroup = db.tblUserInGroups.Where(g => g.GroupID == groupID).ToList();
foreach (tblUserInGroup userInGroup in listTblUserInGroup)
{
db.DeleteObject(userInGroup);
}
int re = db.SaveChanges();
db.Connection.Close();
return(re);
}
public static int DeleteUserGroupPermissionByUserID(int userID)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
List <tblUserGroupPermission> listUserGroupPermission = db.tblUserGroupPermissions.Where(g => g.UserID == userID && g.PermissionType == PERMISSION_TYPE_USER).ToList();
foreach (tblUserGroupPermission userGroupPermission in listUserGroupPermission)
{
db.DeleteObject(userGroupPermission);
}
int re = db.SaveChanges();
db.Connection.Close();
return(re);
}
/// <summary>
/// Deletes the specified user ID.
/// </summary>
/// <param name="userID">The user ID.</param>
/// <returns></returns>
public static int Delete(int userID)
{
try
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
var user = db.tblUsers.Where(g => g.UserID.Equals(userID)).FirstOrDefault();
db.DeleteObject(user);
return(db.SaveChanges());
}
catch (Exception ex)
{
//logger.Error(ex.ToString());
throw;
}
}
public static int Update(tblGroup group)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
var groupOrgin = db.tblGroups.Where(g => g.GroupID == group.GroupID).FirstOrDefault();
if (groupOrgin == null)
{
return(-1);
}
db.Attach(groupOrgin);
db.ApplyPropertyChanges("tblGroups", group);
int re = db.SaveChanges();
db.Connection.Close();
return(re);
}
/// <summary>
/// Update user
/// </summary>
/// <param name="userInfo">userInfo object</param>
/// <returns>Number of rows are effected</returns>
public static int Update(tblUser userInfo)
{
// Encode password & username
userInfo.Password = Common.Encode(userInfo.Password);
var db = new dbTrainEntities(ConnectionController.GetConnection());
var usrOrgin = db.tblUsers.Where(g => g.UserID == userInfo.UserID).FirstOrDefault();
if (usrOrgin == null)
{
return(-1);
}
db.Attach(usrOrgin);
db.ApplyPropertyChanges("tblUsers", userInfo);
return(db.SaveChanges());
}
public static int Update(tblTrain train)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
train.ModifiedDate = CommonFactory.GetCurrentDate();
var originTrain = db.tblTrains.Where(g => g.TrainID == train.TrainID).FirstOrDefault();
if (originTrain == null)
{
return(-1);
}
db.Attach(originTrain);
db.ApplyPropertyChanges("tblTrains", train);
return(db.SaveChanges());
}
public static int UpdateListHandoverReply(tblListHandoverReply handoverReply, List <tblHandover> listHandover)
{
//update all related Handover
RemoveListReplyIDFromHandover(handoverReply.ID);
//update ListHandoverReply
var db = new dbTrainEntities(ConnectionController.GetConnection());
tblListHandoverReply objUpdate = db.tblListHandoverReplies.Where(g => g.ID == handoverReply.ID).FirstOrDefault();
if (objUpdate != null)
{
try
{
objUpdate.ListReplyNumber = handoverReply.ListReplyNumber;
objUpdate.ListReplyDate = handoverReply.ListReplyDate;
objUpdate.ReportFromDate = handoverReply.ReportFromDate;
objUpdate.ReportToDate = handoverReply.ReportToDate;
objUpdate.CustomsCodeReceiver = handoverReply.CustomsCodeReceiver;
objUpdate.ReplyStatusGoods = handoverReply.ReplyStatusGoods;
objUpdate.Note = handoverReply.Note;
//db.SaveChanges();
//db.Dispose();
//db = new dbTrainEntities(ConnectionController.GetConnection());
foreach (tblHandover handover in listHandover)
{
tblHandover obj = db.tblHandovers.Where(g => g.ID == handover.ID).FirstOrDefault();
if (obj != null)
{
obj.tblListHandoverReply = objUpdate;
}
}
return(db.SaveChanges());
}
catch (Exception ex)
{
return(0);
}
}
return(0);
}
public static int RemoveListReplyIDFromHandover(Int64 replyID)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
try
{
//update all related Handover
List <tblHandover> list = db.tblHandovers.Where(g => g.tblListHandoverReply.ID == replyID).ToList();
foreach (tblHandover obj in list)
{
obj.tblListHandoverReply = null;
}
return(db.SaveChanges());
}
catch (Exception ex)
{
return(0);
}
finally
{
db.Dispose();
}
}
