private void prcDisplayDetails(string strParam) { string sqlQuery = "Exec prcGetGroup " + Int32.Parse(strParam); dsDetails = new System.Data.DataSet(); GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, sqlQuery); dsDetails.Tables[0].TableName = "Group"; DataRow dr; if (dsDetails.Tables["Group"].Rows.Count > 0) { dr = dsDetails.Tables["Group"].Rows[0]; this.txtMenuId.Text = dr["mMenuGroupId"].ToString(); this.txtMenuName.Text = dr["mMenuGroupName"].ToString(); this.txtMenuCaption.Text = dr["mMenuGroupCaption"].ToString(); this.cboModule.Text = dr["ModuleId"].ToString(); this.btnDelete.Enabled = true; } }
private void prcLoadList() { GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); dsList = new System.Data.DataSet(); try { string sqlQuery = "Exec [WebprcGetMenu_Web] 0"; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); dsList.Tables[0].TableName = "MenuList"; dsList.Tables[1].TableName = "MenuAll"; dsList.Tables[2].TableName = "asdf"; dsList.Tables[3].TableName = "GroupList"; dsList.Tables[4].TableName = "FieldName"; dsList.Tables[5].TableName = "FieldOperator"; dvgrid = dsList.Tables["MenuList"].DefaultView; gridList.DataSource = null; gridList.DataSource = dvgrid; } finally { clsCon = null; } }
private void gridList_DoubleClick(object sender, EventArgs e) { prcClearData(); txtUserId.Text = gridList.ActiveRow.Cells[0].Value.ToString(); string sqlQuery = "Exec prcGetPermission_Module 0 , " + Int32.Parse(this.txtUserId.Text.ToString()) + ""; GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); dsCombo = new System.Data.DataSet(); try { clsCon.GTRFillDatasetWithSQLCommand(ref dsCombo, sqlQuery); dsDetails.Tables[0].TableName = "ModuleUser"; cboModule.DataSource = null; cboModule.DataSource = dsCombo; cboModule.DisplayMember = "moduleCaption"; cboModule.ValueMember = "moduleId"; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { clsCon = null; } }
//private void txtMenuCaption_MouseClick(object sender, MouseEventArgs e) //{ // clsProc.GTRGotFocus(ref txtMenuLink); //} //private void txtMenuCaption_Enter(object sender, EventArgs e) //{ // clsProc.GTRGotFocus(ref txtMenuLink); //} private void prcDisplayDetails(string strParam) { string sqlQuery = "Exec [WebprcGetMenu_Web] " + Int32.Parse(strParam); dsDetails = new System.Data.DataSet(); GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); dsList = new System.Data.DataSet(); try { clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, sqlQuery); dsDetails.Tables[0].TableName = "Menu"; DataRow dr; if (dsDetails.Tables["Menu"].Rows.Count > 0) { dr = dsDetails.Tables["Menu"].Rows[0]; this.txtMenuId.Text = dr["MenuId"].ToString(); this.txtMenuName.Text = dr["MenuName"].ToString(); this.txtMenuLink.Text = dr["menuLink"].ToString(); this.cboGroup.Value = dr["Parentid"].ToString(); this.chkDropdown.Checked = Boolean.Parse(dr["isInactive"].ToString()); //this.cboGroup.Text = dr["mMenuGroupCaption"].ToString(); //A.parentId, A.isInactive, A.isDefault //this.chkDropdown.Checked = false; //if (Int16.Parse(dr["isInactive"].ToString()) == 1) //{ // this.chkDropdown.Checked = true; //} //else //{ // this.chkDropdown.Checked = false; //} //if (Int16.Parse(dr["IsDropDownParent"].ToString()) == 1) //{ // this.chkIsDDParent.Checked = true; //} //this.cboDDParent.Value = dr["DropdownParentId"].ToString(); cboGroup.ValueMember = "Menuid"; cboGroup.DisplayMember = "MenuName"; this.btnSave.Text = "&Update"; this.btnDelete.Enabled = true; } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { clsCon = null; } }
private void prcLoadList() { GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); dsList = new System.Data.DataSet(); try { string sqlQuery = "Exec prcGetPermission_Module " + clsMain.intUserId + ", 0"; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); dsList.Tables[0].TableName = "UserList"; prcModifyDataset(); gridList.DataSource = null; gridList.DataSource = dsList; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { clsCon = null; } }
private void prcDisplayDetails(string strParam) { string sqlQuery = "Exec prcGetUser " + Common.Classes.clsMain.intUserId + "," + Int32.Parse(strParam); dsDetails = new System.Data.DataSet(); GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, sqlQuery); dsDetails.Tables[0].TableName = "User"; DataRow dr; if (dsDetails.Tables["User"].Rows.Count > 0) { dr = dsDetails.Tables["User"].Rows[0]; this.txtUserId.Text = dr["LUserId"].ToString(); this.txtUserName.Text = clsProc.GTRDecryptWord(dr["LUserName"].ToString()); this.txtPassword.Text = clsProc.GTRDecryptWord(dr["LUserPass"].ToString()); this.txtConfirmPassword.Text = clsProc.GTRDecryptWord(dr["LUserPass"].ToString()); this.cboEmployee.Value = dr["EmpId"].ToString(); this.cboGroup.Text = dr["LSubGroupName"].ToString(); this.chkInactive.Checked = Boolean.Parse(dr["IsInactive"].ToString()); this.txtPassword.Enabled = false; this.txtConfirmPassword.Enabled = false; this.btnSave.Text = "&Update"; this.btnDelete.Enabled = true; } }
private void prcDisplayDetails(string strParam) { string sqlQuery = "Exec prcGetModule " + Int32.Parse(strParam); dsDetails = new System.Data.DataSet(); GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, sqlQuery); dsDetails.Tables[0].TableName = "Module"; DataRow dr; if (dsDetails.Tables["Module"].Rows.Count > 0) { dr = dsDetails.Tables["Module"].Rows[0]; this.txtModuleId.Text = dr["ModuleId"].ToString(); this.txtModuleName.Text = dr["ModuleName"].ToString(); this.txtModuleCaption.Text = dr["ModuleCaption"].ToString(); if (Int16.Parse(dr["IsInactive"].ToString()) == 0) { this.chkInactive.Checked = false; } else { this.chkInactive.Checked = true; } this.btnSave.Text = "&Update"; this.btnDelete.Enabled = true; } }
private void prcLoadList() { GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); dsList = new System.Data.DataSet(); try { string sqlQuery = "Exec prcGetUserMenuPermission " + Common.Classes.clsMain.intUserId + ", 0,0"; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); dsList.Tables[0].TableName = "UserList"; dsList.Tables[1].TableName = "UserListTran"; prcModifyDataset(); gridList.DataSource = null; gridList.DataSource = dsList.Tables["UserList"]; prcModifyDataset1(); gridListTran.DataSource = null; gridListTran.DataSource = dsList.Tables["UserListTran"]; } catch (Exception ex) { throw (ex); } finally { clsCon = null; } }
private void prcLoadList() { GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); dsList = new System.Data.DataSet(); try { string sqlQuery = "Exec WebprcGetWebUser " + Common.Classes.clsMain.intUserId + ", 0"; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); dsList.Tables[0].TableName = "tblWeb_User"; dsList.Tables[1].TableName = "tblWeb_User_1"; dsList.Tables[2].TableName = "tblWeb_User_Category"; dsList.Tables[3].TableName = "tblWeb_User_Type"; dsList.Tables[4].TableName = "tblWeb_SecurityQues"; dsList.Tables[5].TableName = "tblCat_Contact"; dsList.Tables[6].TableName = "tblCat_CustomerInfo"; dsList.Tables[7].TableName = "FieldName"; dsList.Tables[8].TableName = "FieldOperator"; //dsList.Tables[7].TableName = "tblWeb_User_Category"; dvgrid = dsList.Tables["tblWeb_User"].DefaultView; gridList.DataSource = null; gridList.DataSource = dvgrid; } catch (Exception ex) { throw (ex); } finally { clsCon = null; } }
private void prcLoadList() { GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); dsList = new System.Data.DataSet(); try { string sqlQuery = "Exec prcGetMenu 0"; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); dsList.Tables[0].TableName = "MenuList"; dsList.Tables[1].TableName = "ModuleList"; dsList.Tables[2].TableName = "GroupList"; dsList.Tables[3].TableName = "DropdownParent"; dsList.Tables[4].TableName = "FiledName"; dsList.Tables[5].TableName = "FiledOperator"; dvgrid = dsList.Tables["MenuList"].DefaultView; gridList.DataSource = null; gridList.DataSource = dvgrid; } catch (Exception ex) { throw (ex); } finally { clsCon = null; } }
private void prcLoadCombo(string sqlQuery) { GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); dsDetails = new System.Data.DataSet(); try { if (sqlQuery.Length == 0) { sqlQuery = "Exec prcGetPermission_ModuleUser 0, 0"; } clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, sqlQuery); dsDetails.Tables[0].TableName = "ModuleUser"; gridTran.DataSource = null; gridTran.DataSource = dsDetails; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { clsCon = null; } }
private void prcLoadCombo(string sqlQuery) { GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); dsDetails = new System.Data.DataSet(); try { if (sqlQuery.Length == 0) { sqlQuery = "Exec WebprcPermission_MenuUser_Web 0"; } clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, sqlQuery); dsDetails.Tables[0].TableName = "MenuGroup"; dsDetails.Tables[1].TableName = "MenuItem"; DataRelation rel = new DataRelation("relMenu", dsDetails.Tables["MenuGroup"].Columns["MenuGroupId"], dsDetails.Tables["MenuItem"].Columns["MenuGroupId"]); dsDetails.Relations.Add(rel); gridTran.DataSource = null; gridTran.DataSource = dsDetails; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { clsCon = null; } }
private void prcLoadList() { GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); dsList = new System.Data.DataSet(); try { string sqlQuery = "Exec prcGetUserSingle 0," + Common.Classes.clsMain.intUserId + ""; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); dsList.Tables[0].TableName = "tbluser"; DataRow dr; if (dsList.Tables["tbluser"].Rows.Count > 0) { dr = dsList.Tables["tbluser"].Rows[0]; this.txtUserID.Text = clsProc.GTRDecryptWord(dr["luserName"].ToString()).ToString(); this.txtUserName.Text = (dr["empname"].ToString()); } //Load for Filter Filed oparator Name //cboFilterOperator.DataSource = null; //cboFilterOperator.DataSource = dsList.Tables["FilterOperetor"]; } catch (Exception ex) { throw (ex); } finally { clsCon = null; } }
private void prcLoadlist1(string txt) { dsFilter1 = new System.Data.DataSet(); GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); dsList = new System.Data.DataSet(); string sqlQuery; try { //string str = "%" + txt + "%"; if (txt == "Employee") { sqlQuery = "select empID as ID,'[ '+ empCode +' ] - ' + empName COLLATE DATABASE_DEFAULT as Name from tblEmp_Info order by EmpID"; clsCon.GTRFillDatasetWithSQLCommand(ref dsFilter1, sqlQuery); } else if (txt == "Client") { sqlQuery = "select Custid as ID,'[ '+ Custcode +' ] - ' + Custname COLLATE DATABASE_DEFAULT as Name from tblCat_CustomerInfo order by custname"; clsCon.GTRFillDatasetWithSQLCommand(ref dsFilter1, sqlQuery); } else if (txt == "Supplier") { sqlQuery = "select supplierId as ID,'[ '+ SupplierCode +' ] - ' + supplierName COLLATE DATABASE_DEFAULT as Name from tblCat_Supplier order by supplierName"; clsCon.GTRFillDatasetWithSQLCommand(ref dsFilter1, sqlQuery); } else if (txt == "Dealer") { sqlQuery = "select Dlrid as ID,'[ '+ DlrCode +' ] - ' + DlrName COLLATE DATABASE_DEFAULT as Name from tblCat_DealerInfo order by DlrName"; clsCon.GTRFillDatasetWithSQLCommand(ref dsFilter1, sqlQuery); } dsFilter1.Tables[0].TableName = "as"; cboRefName.DataSource = null; cboRefName.DataSource = dsFilter1.Tables["as"]; cboRefName.DisplayMember = "name"; cboRefName.ValueMember = "id"; } catch (Exception ex) { // throw (ex); } }
private void btnSave_Click(object sender, EventArgs e) { GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); try { string LUserId = gridList.ActiveRow.Cells["LUserId"].Value.ToString(); string LUserIdTran = gridListTran.ActiveRow.Cells["LUserId"].Value.ToString(); string sqlQuery = "Exec prcGetUserMenuPermission " + Common.Classes.clsMain.intUserId + ", " + LUserId + "," + LUserIdTran + ""; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); // Insert Information To Log File string sqlQuery1 = "Insert Into tblUser_Trans_Log (LUserId, formName, tranStatement, PCName, tranType)" + " Values (" + GTRHRIS.Common.Classes.clsMain.intUserId + ", '" + this.Name.ToString() + "','" + sqlQuery.Replace("'", "|") + "','" + Common.Classes.clsMain.strComputerName + "','Save')"; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery1); //// Insert Information To Log File //string sqlQuery1 = "Insert Into tblUser_Trans_Log (LUserId, formName, tranStatement, PCName, tranType)" // + " Values (" + GTRHRIS.Common.Classes.clsMain.intUserId + ", '" + this.Name.ToString() + // "','" + sqlQuery.Replace("'", "|") + "','" + Common.Classes.clsMain.strComputerName + "','Save')"; //arQuery.Add(sqlQuery); ////Transaction with database //clsCon.GTRSaveDataWithSQLCommand(arQuery); //MessageBox.Show("Data Updated Successfully"); MessageBox.Show("Data Saved Successfully"); prcClearData(); prcLoadList(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { clsCon = null; } }
public void prcGetData(ref System.Data.DataSet dsMenu) { GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); clsCon.GTRFillDatasetWithSQLCommand(ref dsMenu, "Exec prcGetMenuPermission " + (Int32)Classes.clsMain.intUserId); dsMenu.Tables[0].TableName = "Module"; dsMenu.Tables[1].TableName = "Group"; dsMenu.Tables[2].TableName = "Menu"; dsMenu.Tables[3].TableName = "Company"; }
private void prcLoadlist2(string txt, string int1) { dsFilter2 = new System.Data.DataSet(); GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); dsList = new System.Data.DataSet(); string sqlQuery; try { //string str = "%" + txt + "%"; if (txt == "Client" || txt == "Customer") { sqlQuery = "select contID as ID,'[ '+ contCode +' ] - ' + contName COLLATE DATABASE_DEFAULT as Name from tblCat_Contact where TypeName = 'Customer' and DataID = " + int1 + " "; clsCon.GTRFillDatasetWithSQLCommand(ref dsFilter2, sqlQuery); } else if (txt == "Supplier") { sqlQuery = "select contID as ID,'[ '+ contCode +' ] - ' + contName COLLATE DATABASE_DEFAULT as Name from tblCat_Contact where TypeName = 'Supplier' and DataID = " + int1 + " order by Name"; clsCon.GTRFillDatasetWithSQLCommand(ref dsFilter2, sqlQuery); } else if (txt == "Dealer") { sqlQuery = "select contID as ID,'[ '+ contCode +' ] - ' + contName COLLATE DATABASE_DEFAULT as Name from tblCat_Contact where TypeName = 'Supplier' and DataID = " + int1 + " order by Name"; clsCon.GTRFillDatasetWithSQLCommand(ref dsFilter2, sqlQuery); } dsFilter2.Tables[0].TableName = "as"; cboRelation.DataSource = null; cboRelation.DataSource = dsFilter2.Tables["as"]; cboRelation.DisplayMember = "name"; cboRelation.ValueMember = "id"; } catch (Exception ex) { throw (ex); } }
private void btnSave_Click(object sender, EventArgs e) { if (fncBlank()) { return; } ArrayList arQuery = new ArrayList(); GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); string sqlQuery = ""; Int32 NewId = 0; try { //Check old password System.Data.DataSet ds = new System.Data.DataSet(); sqlQuery = "Select * from tblLogin_user Where LUserId = " + Common.Classes.clsMain.intUserId + ""; clsCon.GTRFillDatasetWithSQLCommand(ref ds, sqlQuery); if (ds.Tables[0].Rows.Count == 0) { MessageBox.Show("Please provide valid old password"); txtOldPassword.Focus(); return; } ds = null; //Update database sqlQuery = " Update tblLogin_User Set LUserPass='******' Where LUserId = " + Common.Classes.clsMain.intUserId + ""; arQuery.Add(sqlQuery); //Transaction with database clsCon.GTRSaveDataWithSQLCommand(arQuery); MessageBox.Show("Data Updated Successfully"); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { arQuery = null; clsCon = null; } }
private void gridList_DoubleClick(object sender, EventArgs e) { prcClearData(); //txtUserId.Text = gridList.ActiveRow.Cells[0].Value.ToString(); string sqlQuery = "Exec WebprcPermission_MenuUser_Web " + gridList.ActiveRow.Cells[0].Text.ToString() + ""; //DataRelation rel = new DataRelation("relMenu", dsDetails.Tables["MenuGroup"].Columns["MenuGroupId"], dsDetails.Tables["MenuItem"].Columns["MenuGroupId"]); //dsDetails.Relations.Add(rel); //gridTran.DataSource = null; //gridTran.DataSource = dsDetails; GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); dsCombo = new System.Data.DataSet(); try { clsCon.GTRFillDatasetWithSQLCommand(ref dsCombo, sqlQuery); dsCombo.Tables[0].TableName = "MenuGroup"; dsCombo.Tables[1].TableName = "MenuItem"; DataRelation rel = new DataRelation("relMenu", dsCombo.Tables["MenuGroup"].Columns["MenuGroupId"], dsCombo.Tables["MenuItem"].Columns["MenuGroupId"]); dsCombo.Relations.Add(rel); gridTran.DataSource = null; gridTran.DataSource = dsCombo; //cboModule.DataSource = null; //cboModule.DataSource = dsCombo; //cboModule.DisplayMember = "moduleCaption"; //cboModule.ValueMember = "moduleId"; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { clsCon = null; } }
private void prcDisplayDetails(string strParam) { string sqlQuery = "Exec WebprcGetWebUser " + Common.Classes.clsMain.intUserId + "," + Int32.Parse(strParam); dsDetails = new System.Data.DataSet(); GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); dsList = new System.Data.DataSet(); clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, sqlQuery); dsDetails.Tables[0].TableName = "User"; DataRow dr; if (dsDetails.Tables["User"].Rows.Count > 0) { dr = dsDetails.Tables["User"].Rows[0]; this.txtUserId.Text = dr["UserID"].ToString(); this.txtUserName.Text = dr["UserName"].ToString(); this.txtPassword.Text = dr["UserPass"].ToString(); this.txtConfirmPassword.Text = dr["UserPass"].ToString(); this.chkInactive.Checked = Boolean.Parse(dr["IsInactive"].ToString()); this.cboQuestion.Text = dr["SecQuestion"].ToString(); this.cboAnswer.Text = dr["SecAnswer"].ToString(); this.txtDisplayName.Text = dr["DisplayName"].ToString(); this.cboUsType.Value = dr["userTypeId"].ToString(); this.cboGroup.Value = dr["userCatId"].ToString(); this.cboRefName.Value = dr["refid"].ToString(); this.cboRelation.Value = dr["RelId"].ToString(); //this.chkInactive.CheckedValue = dr["isInactive"].ToString(); this.txtPassword.Enabled = false; this.txtConfirmPassword.Enabled = false; this.btnSave.Text = "&Update"; this.btnDelete.Enabled = true; } }
private void prcDisplayDetails(string strParam) { string sqlQuery = "Exec prcGetUserGroup " + Common.Classes.clsMain.intUserId + "," + Int32.Parse(strParam); dsDetails = new System.Data.DataSet(); GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, sqlQuery); dsDetails.Tables[0].TableName = "Group"; DataRow dr; if (dsDetails.Tables["Group"].Rows.Count > 0) { dr = dsDetails.Tables["Group"].Rows[0]; this.txtGroupId.Text = dr["LSubGroupId"].ToString(); this.txtGroupName.Text = dr["LSubGroupName"].ToString(); this.btnSave.Text = "&Update"; this.btnDelete.Enabled = true; } }
private void prcLoadList() { GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); dsList = new System.Data.DataSet(); try { string sqlQuery = "Exec prcGetModule 0"; clsCon.GTRFillDatasetWithSQLCommand(ref dsList, sqlQuery); dsList.Tables[0].TableName = "ModuleList"; gridList.DataSource = null; gridList.DataSource = dsList; } catch (Exception ex) { throw (ex); } finally { clsCon = null; } }
private void prcDisplayDetails(string strParam) { string sqlQuery = "Exec prcGetMenu " + Int32.Parse(strParam); dsDetails = new System.Data.DataSet(); GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection(); try { clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, sqlQuery); dsDetails.Tables[0].TableName = "Menu"; DataRow dr; if (dsDetails.Tables["Menu"].Rows.Count > 0) { dr = dsDetails.Tables["Menu"].Rows[0]; this.txtMenuId.Text = dr["MenuId"].ToString(); this.txtMenuName.Text = dr["MenuName"].ToString(); this.txtMenuCaption.Text = dr["MenuCaption"].ToString(); this.txtFormName.Text = dr["frmName"].ToString(); this.txtFormLocation.Text = dr["frmLocation"].ToString(); this.cboModule.Value = dr["ModuleId"].ToString(); this.cboModule.Text = dr["ModuleCaption"].ToString(); this.cboGroup.Value = dr["mMenuGroupId"].ToString(); this.cboGroup.Text = dr["mMenuGroupCaption"].ToString(); if (Int16.Parse(dr["menuImageExist"].ToString()) != 0) { optImageUse.CheckedIndex = 1; if (Int16.Parse(dr["menuImageSize"].ToString()) == 2) { optImageUse.CheckedIndex = 2; } txtImageName.Text = dr["menuImageName"].ToString(); //txtImageName.Tag = dr["menuImageName"].ToString(); picPreview.Image = new Bitmap(@"Z:\Com\pics\Icon\" + txtImageName.Text); } this.chkDropdown.Checked = false; if (Int16.Parse(dr["IsDropDown"].ToString()) == 1) { this.chkDropdown.Checked = true; } this.chkIsDDParent.Checked = false; if (Int16.Parse(dr["IsDropDownParent"].ToString()) == 1) { this.chkIsDDParent.Checked = true; } this.cboDDParent.Value = dr["DropdownParentId"].ToString(); this.btnSave.Text = "&Update"; this.btnDelete.Enabled = true; } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { clsCon = null; } }