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