private void LoadDataByID(int iGpD) { Group oGp = new Group(iGpD); GroupDAL oGpDAL = new GroupDAL(); Result oResult = new Result(); oResult = oGpDAL.LoadByID(oGp); ClearTextValue(); if (oResult.Status) { oGp = (Group)oResult.Return; if (oGp != null) { SetObject(oGp); } else { ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_INFO); ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true); } } else { ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR); ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("Delete"), true); } }
// ok protected void btnDelete_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(hdGpID.Value)) { GroupDAL oGpDAL = new GroupDAL(); Result oResult = (Result)oGpDAL.Detete(hdGpID.Value); if (oResult.Status) { //this.LoadList(); this.ClearTextValue(); ucMessage.OpenMessage(Constants.MSG_SUCCESS_DELETE, Constants.MSG_TYPE_SUCCESS); } else { if (oResult.Message.Equals(Constants.TABLE_MAIN)) { ucMessage.OpenMessage(Constants.MSG_APPROVED_DELETE_DATA, Constants.MSG_TYPE_ERROR); } else { ucMessage.OpenMessage(Constants.MSG_ERROR_DELETE, Constants.MSG_TYPE_ERROR); } } } else { ucMessage.OpenMessage(Constants.MSG_ERROR_DELETE, Constants.MSG_TYPE_ERROR); } }
private void dataGridViewGroups_CellClick(object sender, DataGridViewCellEventArgs e) { DataTable dtGroupStudents = GroupDAL.GetGroupStudents( (int)dataGridViewGroups.Rows[dataGridViewGroups.SelectedCells[0].RowIndex].Cells["Group ID"].Value); this.dataGridViewGroupStudents.DataSource = dtGroupStudents; }
protected void btnSave_Click(object sender, EventArgs e) { Group oGp = new Group(); GroupDAL oGpDAL = new GroupDAL(); oGp.GroupID = Util.GetIntNumber(Request[txtGroupID.UniqueID].Trim()); oGp.GroupName = txtGroupName.Text; oGp.Description = txtDescription.Text; oGp.Department.DepartmentID = Util.GetIntNumber(ddlDepartmentID.SelectedValue); oGp.ScreenList = GetScreenList(); oGp.UserDetails = ucUserDet.UserDetail; oGp.UserDetails.CheckDate = DateTime.Now; oGp.UserDetails.CheckerID = oGp.UserDetails.MakerID; Result oResult = (Result)oGpDAL.Save(oGp); if (oResult.Status) { ClearTextValue(); //LoadList(); ucMessage.OpenMessage(Constants.MSG_SUCCESS_SAVE, Constants.MSG_TYPE_SUCCESS); } else { ucMessage.OpenMessage(Constants.MSG_ERROR_SAVE, Constants.MSG_TYPE_ERROR); } }
public static List <Group> GetStubNumber(NameValueCollection querystring) { string criteria = querystring.Get("Criteria"); int branchID = int.TryParse(querystring.Get("BranchID"), out branchID) ? branchID : 0; return(GroupDAL.GetGroup(criteria, branchID)); }
public static IEnumerable <GroupInfo> GetGroupsToDisplay(String id) { var grpList = GroupDAL.GetGroups(); var groups = new List <GroupInfo>(); var joined = false; foreach (var g in grpList) { foreach (var userG in g.UserGroups) { if (userG.UserId.Equals(id)) { joined = true; break; } } var tmp = new GroupInfo(); tmp.Name = g.Name; tmp.Id = g.Id; tmp.Joined = joined; groups.Add(tmp); joined = false; } return(groups); }
private void MoveAction(string sType) { GroupDAL oGpDAL = new GroupDAL(); Result oResult = oGpDAL.LoadMoveData(txtGroupName.Text, sType); ClearTextValue(); if (oResult.Status) { Group oGp = (Group)oResult.Return; if (oGp != null) { SetObject(oGp); hdGpID.Value = oGp.GroupID.ToString(); } else { ucMessage.OpenMessage("Group Name does not exist", Constants.MSG_TYPE_INFO); ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("Info"), true); } } else { ucMessage.OpenMessage("Group Name does not exist", Constants.MSG_TYPE_INFO); ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("Info"), true); } }
private void TeacherStudyGroups_Load(object sender, EventArgs e) { DataTable dtGroups = TeacherDAL.GetTeacherGroups(TeacherID);//TeacherDAL.GetTeacherStudents(TeacherID); this.dataGridViewGroups.DataSource = dtGroups; foreach (DataGridViewColumn dc in dataGridViewGroups.Columns) { if (dc.Name != "Description") { dc.ReadOnly = true; } } this.dataGridViewGroups.Update(); //bind binging navigator to data grid var bs = new BindingSource(); bs.DataSource = dtGroups.DefaultView; bindingNavigator1.BindingSource = bs; dataGridViewGroups.DataSource = bs; DataTable dtGroupStudents = GroupDAL.GetGroupStudents((int)dataGridViewGroups.Rows[dataGridViewGroups.SelectedCells[0].RowIndex].Cells["Group ID"].Value); this.dataGridViewGroupStudents.DataSource = dtGroupStudents; toolStripTeacherID.Text = "Teacher ID: " + TeacherID.ToString(); }
public static void UpdateGroup(GroupInfo groupInfo) { var grp = GetGroup(groupInfo); grp.Name = groupInfo.Name; GroupDAL.UpdateGroup(grp); }
private void btnRemoveStudentFromGroup_Click(object sender, EventArgs e) { try { if (studentsDataGridView.CurrentRow.IsNewRow) { throw new ArgumentOutOfRangeException("You cannot delete non-existant group student from this group!"); } int rowIndex = studentsDataGridView.SelectedCells[0].RowIndex; int studentID = int.Parse(studentsDataGridView["Student_ID", rowIndex].EditedFormattedValue.ToString()); int groupID = int.Parse(studentsDataGridView["Group_ID", rowIndex].EditedFormattedValue.ToString()); if (MessageBox.Show(string.Format("Do you really want to delete student {0} {1} from group #{2}?", studentsDataGridView["Last_name", rowIndex].EditedFormattedValue.ToString(), studentsDataGridView["First_name", rowIndex].EditedFormattedValue.ToString(), groupID), "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Yes) { GroupDAL.RemoveStudentFromGroup(groupID, studentID); studentsDataGridView.Rows.RemoveAt(rowIndex); MessageBox.Show("Student successfully removed from the group!", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (NullReferenceException) { MessageBox.Show("Maybe, you haven't selected a student?", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public List <Group> GetGroupListByUserId(int userid) { List <Group> list = new List <Group>(); GroupDAL dal = new GroupDAL(); list = dal.GetGroupsByUserid(userid); return(list); }
public List <Group> GetGroupList() { List <Group> list = new List <Group>(); GroupDAL dal = new GroupDAL(); list = dal.GetAllGroup(); return(list); }
public ActionResult Create() { UserCreateViewModel model = new UserCreateViewModel(); GroupDAL groupDAL = new GroupDAL(); model.DdlGroupID = groupDAL.DdlGroup(); return(View("Create", model)); }
public static Group CreateGroup(string name, DateTime startDate, DateTime endDate, int tourId) { ValidateGroup(name, startDate, endDate); var group = new Group(name, startDate, endDate, tourId); GroupDAL.Add(group); return(group); }
public static GroupInfo GetGroup(int groupId) { var group = GroupDAL.GetGroup(groupId); var groupInfo = new GroupInfo(); groupInfo.Id = group.Id; groupInfo.Name = group.Name; return(groupInfo); }
public static Group EditGroup(int id, string name, DateTime startDate, DateTime endDate, int tourId) { ValidateGroup(name, startDate, endDate); var group = new Group(name, startDate, endDate, tourId) { Id = id }; GroupDAL.Update(group); return(group); }
private void dataGridViewGroups_CellEndEdit(object sender, DataGridViewCellEventArgs e) { try { //at the momment we can only edit "Description" column GroupDAL.UpdateGroup((int)dataGridViewGroups.Rows[dataGridViewGroups.SelectedCells[0].RowIndex].Cells["Group ID"].Value, dataGridViewGroups.Rows[dataGridViewGroups.SelectedCells[0].RowIndex].Cells["Description"].Value.ToString()); MessageBox.Show("Changes successfully saved!"); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public static void AddGroup(GroupInfo groupInfo) { var groups = GetGroups(); foreach (var g in groups) { if (g.Name.Equals(groupInfo.Name)) { return; } } var group = new Group(); group.Name = groupInfo.Name; GroupDAL.AddGroupToDB(group); }
public static IEnumerable <GroupInfo> GetGroups() { var grpList = GroupDAL.GetGroups(); var groups = new List <GroupInfo>(); foreach (var g in grpList) { var tmp = new GroupInfo(); tmp.Name = g.Name; tmp.Id = g.Id; groups.Add(tmp); } return(groups); }
// To pass 'Group' data in GroupDAL Data Access Layer to show Active and Inactive type records public DataTable LoadActiveGroup(bool IsActive,int LoggedInUser, string returnmsg) { GroupDAL GroupDAL = new GroupDAL(); try { return GroupDAL.LoadActiveGroup(IsActive, LoggedInUser, returnmsg); } catch { throw; } finally { GroupDAL = null; } }
// To pass 'Group' data in GroupDAL Data Access Layer for insertion public int InsertGroup(string GroupName ,string GroupDescription,bool Isactive,int LoginUser, string Ret) { GroupDAL GroupDAL = new GroupDAL(); try { return GroupDAL.InsertGroup(GroupName,GroupDescription, Isactive, LoginUser,Ret); } catch { throw; } finally { GroupDAL = null; } }
// To pass 'Group' data in GroupDAL Data Access Layer to show Change Status of selected GroupId record public int ChangeGroupStatus(int GroupId, int LoggedInUser, string returnmsg, bool IsActive) { GroupDAL GroupDAL = new GroupDAL(); try { return GroupDAL.ChangeGroupStatus(GroupId, LoggedInUser, returnmsg, IsActive); } catch { throw; } finally { GroupDAL = null; } }
// To pass 'Group' data in GroupDAL Data Access Layer to show Active type records public DataTable LoadAllGroup(int LoggedInUser,string returnmsg) { GroupDAL GroupDAL = new GroupDAL(); try { return GroupDAL.LoadAllGroup(LoggedInUser, returnmsg); } catch { throw; } finally { GroupDAL = null; } }
// To pass 'Group' data in GroupDAL Data Access Layer to show Active and Inactive type records public DataTable LoadActiveGroup(bool IsActive, int LoggedInUser, string returnmsg) { GroupDAL GroupDAL = new GroupDAL(); try { return(GroupDAL.LoadActiveGroup(IsActive, LoggedInUser, returnmsg)); } catch { throw; } finally { GroupDAL = null; } }
// To pass 'Group' data in GroupDAL Data Access Layer to show selected GroupId record public DataTable SelectGroupID(int GroupId, int LoggedInUser, string returnmsg) { GroupDAL GroupDAL = new GroupDAL(); try { return(GroupDAL.SelectGroupID(GroupId, LoggedInUser, returnmsg)); } catch { throw; } finally { GroupDAL = null; } }
// To pass 'Group' data in GroupDAL Data Access Layer for updation public int UpdateGroup(int GroupId, string GroupDescription, bool IsActive, string GroupName, int LoginUser, string Ret) { GroupDAL GroupDAL = new GroupDAL(); try { return(GroupDAL.UpdateGroup(GroupId, GroupDescription, IsActive, GroupName, LoginUser, Ret)); } catch { throw; } finally { GroupDAL = null; } }
// To pass 'Group' data in GroupDAL Data Access Layer to show Active type records public DataTable LoadAllGroup(int LoggedInUser, string returnmsg) { GroupDAL GroupDAL = new GroupDAL(); try { return(GroupDAL.LoadAllGroup(LoggedInUser, returnmsg)); } catch { throw; } finally { GroupDAL = null; } }
// To pass 'Group' data in GroupDAL Data Access Layer to show Change Status of selected GroupId record public int ChangeGroupStatus(int GroupId, int LoggedInUser, string returnmsg, bool IsActive) { GroupDAL GroupDAL = new GroupDAL(); try { return(GroupDAL.ChangeGroupStatus(GroupId, LoggedInUser, returnmsg, IsActive)); } catch { throw; } finally { GroupDAL = null; } }
// To pass 'Group' data in GroupDAL Data Access Layer for insertion public int InsertGroup(string GroupName, string GroupDescription, bool Isactive, int LoginUser, string Ret) { GroupDAL GroupDAL = new GroupDAL(); try { return(GroupDAL.InsertGroup(GroupName, GroupDescription, Isactive, LoginUser, Ret)); } catch { throw; } finally { GroupDAL = null; } }
private void btnAddStudentToGroup_Click(object sender, EventArgs e) { try { if (GroupsDataGridView.CurrentRow.IsNewRow) { throw new Exception("You cannot add students to non-existant group!"); } int rowIndex = GroupsDataGridView.SelectedCells[0].RowIndex; AddStudentToGroupDialog dialog = new AddStudentToGroupDialog(GroupsDataGridView["Grade", rowIndex].EditedFormattedValue.ToString()); //dialog.Owner = this; dialog.FormClosed += (o, s) => { if (dialog.StudentID != 0) { //studentsDataGridView.Rows.Add(dialog.GradeSection, dialog.LastName, dialog.FirstName, dialog.StudentID); //add new student try { GroupDAL.AddStudentToGroup( int.Parse(GroupsDataGridView["GroupID", rowIndex].Value.ToString()), dialog.StudentID); this.getGroupStudentsTableAdapter.Fill(this.schooljournalDataSet.getGroupStudents, int.Parse(GroupsDataGridView["GroupID", rowIndex].Value.ToString())); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { } } }; dialog.ShowDialog(); } catch (Exception ex) { string msg = ex.Message; if (ex.InnerException != null) { msg += "\n" + ex.InnerException.Message; } MessageBox.Show(msg, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public static string ManageGroup(NameValueCollection querystring) { int intParser; UserProfile userProfile = WebCommon.GetUserProfile(); var group = new Group { GroupID = int.TryParse(querystring.Get("GroupID"), out intParser) ? intParser : 0, Description = querystring.Get("Description"), UserID = userProfile.UserId }; string isInsert = querystring.Get("TransType"); string param = WebCommon.ToXML(group); return(GroupDAL.ManageGroup(param, isInsert)); }
private void saveGroups() { SchoolJournalEntities context = new SchoolJournalEntities(); var groupIDs = from g in context.Groups select g.GroupID; try { foreach (DataGridViewRow r in GroupsDataGridView.Rows) { if (r.IsNewRow) { continue; } int groupID = int.Parse(GroupsDataGridView["GroupID", r.Index].Value.ToString()); if (groupIDs.Contains(groupID)) //update { GroupDAL.UpdateGroup(groupID, int.Parse(GroupsDataGridView["TeacherID", r.Index].Value.ToString()), GroupsDataGridView["Subject", r.Index].EditedFormattedValue.ToString(), GroupsDataGridView["Grade", r.Index].EditedFormattedValue.ToString(), GroupsDataGridView["Description", r.Index].Value.ToString()); } else //add new { GroupsDataGridView["GroupID", r.Index].Value = GroupDAL.NewGroup(int.Parse(GroupsDataGridView["TeacherID", r.Index].Value.ToString()), GroupsDataGridView["Subject", r.Index].EditedFormattedValue.ToString(), GroupsDataGridView["Grade", r.Index].EditedFormattedValue.ToString(), GroupsDataGridView["Description", r.Index].Value.ToString()); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { context.Dispose(); } }
public ActionResult Index(string token = "") { if (!string.IsNullOrEmpty(token)) { if (token == MTConfig.AdminToken) { MTConfig.CurrentUser = UserModel.FirstOrDefault("where Id = 1 "); } } if (MTConfig.CurrentUser == null) { return(RedirectToAction("Login")); } //List<NoticeModel> notmodels = // NoticeModel.Fetch("select top 10 * from Notice where userid = @0 and ConfirmTime is NULL", // MTConfig.CurrentUserID); //foreach (var item in notmodels) //{ // item.SendDate = DateTimeHelper.showTime(item.SendTime); //} //ViewBag.notmodels = notmodels; //int notcount = // NoticeModel.repo.ExecuteScalar<int>( // "select count(*) from Notice where userid = @0 and ConfirmTime is NULL", MTConfig.CurrentUserID); //ViewBag.notcount = notcount; #region 刷新当前用户权限信息 IndexViewModel model = new IndexViewModel(); MTConfig.AuthInfo = NodeDAL.GetAccessNodeList(MTConfig.CurrentUserID); model.NodeList = MTConfig.AuthInfo; MTConfig.CurrentRole = RoleDAL.GetAllRoleByUserID(MTConfig.CurrentUserID); MTConfig.CurrentUser = UserModel.FirstOrDefault("where Id = @0", MTConfig.CurrentUserID); model.UserInfo = MTConfig.CurrentUser; model.GroupList = GroupDAL.GetAllGroup(); #endregion return(View(model)); }
public ActionResult Create(UserCreateViewModel userCreateViewModel) { try { if (!ModelState.IsValid) { GroupDAL groupDAL = new GroupDAL(); userCreateViewModel.DdlGroupID = groupDAL.DdlGroup(); return(View(userCreateViewModel)); } userDAL.CreateUser(userCreateViewModel); return(RedirectToAction("Index", "Users", new { area = "Admin" })); } catch (Exception ex) { GroupDAL groupDAL = new GroupDAL(); userCreateViewModel.DdlGroupID = groupDAL.DdlGroup(); ModelState.AddModelError("", ex.Message); return(View()); } }
// To pass 'Group' data in GroupDAL Data Access Layer for updation public int UpdateGroup(int GroupId,string GroupDescription, bool IsActive, string GroupName, int LoginUser, string Ret) { GroupDAL GroupDAL = new GroupDAL(); try { return GroupDAL.UpdateGroup(GroupId, GroupDescription,IsActive, GroupName, LoginUser, Ret); } catch { throw; } finally { GroupDAL = null; } }
// To pass 'Group' data in GroupDAL Data Access Layer to show selected GroupId record public DataTable SelectGroupID(int GroupId,int LoggedInUser, string returnmsg) { GroupDAL GroupDAL = new GroupDAL(); try { return GroupDAL.SelectGroupID(GroupId, LoggedInUser, returnmsg); } catch { throw; } finally { GroupDAL = null; } }