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