private void btnUnlockRoom_Click(object sender, EventArgs e) { lbmsgAlert.Text = ""; string msgdisplay = ""; DateTime dateNow = Program.GetServerDateTime(); for (int iRow = 0; iRow <= GridRoomLock.Rows.Count - 1; iRow++) { Boolean isselect = Convert1.ToBoolean(GridRoomLock["Colselect", iRow].Value); int mrdid = Convert1.ToInt32(GridRoomLock["Colmrd_id", iRow].Value); if (isselect == true) { using (InhCheckupDataContext cdc = new InhCheckupDataContext()) { cdc.log_user_logins.Where(x => x.mrd_id == mrdid && x.lug_end_date == null).ToList() .ForEach(x => x.lug_end_date = dateNow); cdc.SubmitChanges(); } msgdisplay = "Unlock completed."; } } btnsearch_Click(null, null); ShowRoomLock(0); lbmsgAlert.Text = msgdisplay; }
private void btnsearch_Click(object sender, EventArgs e) { lbmsgAlert.Text = ""; int mhsid = Convert1.ToInt32(DDSite.SelectedValue); int mrmid = Convert1.ToInt32(DDRoom.SelectedValue); LoadGrid(mhsid, mrmid); }
public static int?GetValueComboBoxInt(ComboBox cmd) { try { DropdownData castedItem = (DropdownData)cmd.SelectedItem; return(Convert1.ToInt32(castedItem.Code)); } catch (Exception) { } return(null); }
private void ShowRoomLock(int rowid) { int mrmid = Convert1.ToInt32(GridSiteRoom["ColmrmID", rowid].Value); /* select mrd.mrd_ename, COUNT(1) * from mst_room_dtl mrd, * log_user_login lug * where mrd.mrd_id = lug.mrd_id * and lug.lug_end_date is null * and mrd.mrm_id = mrm_id * group by mrd.mrd_ename * ]*/ var objlistLock = (from lug in dbc.log_user_logins from mrd in dbc.mst_room_dtls from mut in dbc.mst_user_types where mrd.mrd_id == lug.mrd_id && lug.lug_end_date == null && mrd.mrm_id == mrmid && lug.mut_id == mut.mut_id select new { mrd.mrd_ename, mrd.mrd_id, mut.mut_username, name = mut.mut_t_fname + " " + mut.mut_t_lname }).ToList(); var objgroup = objlistLock.GroupBy(x => x).Select(group => new { mrd_ename = group.FirstOrDefault().mrd_ename, mrd_id = group.FirstOrDefault().mrd_id, countperson = group.Count(), username = group.FirstOrDefault().mut_username, name = group.FirstOrDefault().name }).OrderBy(x => x.mrd_ename); GridRoomLock.DataSource = objgroup.ToList(); }