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