public void BindFileCabinets() { try { string RoleID = UserAccessPermissionvalues.RoleID; string UserID = UserAccessPermissionvalues.UserID; if (RoleID != null && UserID != null) { FileCabinetManager objFileCabinetManager = new FileCabinetManager(); NandanaResult result = new NandanaResult(); result = objFileCabinetManager.GetFileCabinets(); if (!result.HasError && result.resultDS.Tables[0].Rows.Count > 0) { cmbFileCabinet.Items.Clear(); cmbFileCabinet.DisplayMember = "FileCabinet_Name"; cmbFileCabinet.ValueMember = "FileCabinet_ID"; cmbFileCabinet.DataSource = GetComboBoxedDataTable(result.resultDS.Tables[0], "FileCabinet_ID", "FileCabinet_Name", "0", "Choose a Cabinet"); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error While retriving data from Filecabinet table"); } }
private void btnOK_Click(object sender, EventArgs e) { bool status = true; if (txtFileCabinet.Text == String.Empty) { lblErrorMsg.Visible = true; lblErrorMsg.Text = "Cabinet name is required"; status = false; txtFileCabinet.Focus(); return; } if (!status) { MessageBox.Show("Please Enter required data"); } else { try { // Checking duplicate cabinet names FileCabinetManager objFileCabinetManager = new FileCabinetManager(); NandanaResult result = new NandanaResult(); result = objFileCabinetManager.GetFileCabinets(); if (!result.HasError && result.resultDS.Tables[0].Rows.Count > 0) { foreach (DataRow dr in result.resultDS.Tables[0].Rows) { string CabinetName = dr["FileCabinet_Name"].ToString(); if (CabinetName.ToUpper() == txtFileCabinet.Text.ToUpper()) { lblErrorMsg.Visible = true; lblErrorMsg.Text = "Cabinet already exists, type a new name"; status = false; txtFileCabinet.Focus(); return; } } } //end //* inserting File Cabinet details in FileCabinet table *// NandanaResult insertFileCabinet = objFileCabinetManager.InsertFileCabinetDetails(txtFileCabinet.Text.Trim(), "True"); if (insertFileCabinet.resultDS != null && insertFileCabinet.resultDS.Tables[0].Rows.Count > 0) { DataRow dr = insertFileCabinet.resultDS.Tables[0].Rows[0]; FileCabinetID = dr["CabinetID"].ToString(); FileCabinetName = txtFileCabinet.Text; } //* End *// this.Hide(); } catch (Exception x) { MessageBox.Show(x.Message, "Error while Inserting Data from InsertFileCabinet SP"); } } }
private void btnOK_Click(object sender, EventArgs e) { bool status = true; if (txtFileCabinet.Text == String.Empty) { pnlError.Visible = true; pnlError.Location = new Point((this.Width - pnlError.ClientSize.Width) / 2, 64); pnlError.BackColor = System.Drawing.ColorTranslator.FromHtml("#f5b7b7"); lblErrorMsg.Text = "Cabinet name is required"; lblErrorMsg.Location = new Point((pnlError.Width - lblErrorMsg.ClientSize.Width) / 2, (pnlError.Height - lblErrorMsg.ClientSize.Height) / 2); status = false; txtFileCabinet.Focus(); return; } if (!status) { MessageBox.Show("Please Enter required data"); } else { try { // Checking duplicate cabinet names FileCabinetManager objFileCabinetManager = new FileCabinetManager(); NandanaResult result = new NandanaResult(); result = objFileCabinetManager.GetFileCabinets(); if (!result.HasError && result.resultDS.Tables[0].Rows.Count > 0) { foreach (DataRow dr in result.resultDS.Tables[0].Rows) { string CabinetName = dr["FileCabinet_Name"].ToString(); if (CabinetName.ToUpper() == txtFileCabinet.Text.ToUpper()) { pnlError.Visible = true; pnlError.Location = new Point((this.Width - pnlError.ClientSize.Width) / 2, 64); pnlError.BackColor = System.Drawing.ColorTranslator.FromHtml("#f5b7b7"); lblErrorMsg.Text = "Cabinet already exists, type a new name"; lblErrorMsg.Location = new Point((pnlError.Width - lblErrorMsg.ClientSize.Width) / 2, (pnlError.Height - lblErrorMsg.ClientSize.Height) / 2); status = false; txtFileCabinet.Focus(); return; } } } //end //* inserting File Cabinet details in FileCabinet table *// NandanaResult insertFileCabinet = objFileCabinetManager.InsertFileCabinetDetails(txtFileCabinet.Text.Trim(), "True"); if (insertFileCabinet.resultDS != null && insertFileCabinet.resultDS.Tables[0].Rows.Count > 0) { DataRow dr = insertFileCabinet.resultDS.Tables[0].Rows[0]; FileCabinetID = dr["CabinetID"].ToString(); FileCabinetName = txtFileCabinet.Text; } //* End *// DashBoardHome obj = new DashBoardHome(); obj.strRootNodeID = FileCabinetID; obj.strRootNode = FileCabinetName; obj.MdiParent = (NewMenu)this.MdiParent; obj.Show(); this.Hide(); } catch (Exception x) { MessageBox.Show(x.Message, "Error while Inserting Data from InsertFileCabinet SP"); } } }