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