private void GetMenuData() { try { DataTable table = new DataTable(); _objUserPermissionController = new UserPermissionController(); if (LoginUserInformation.UserID == "160ea939-7633-46a8-ae49-f661d12abfd5") { table = _objUserPermissionController.GetData(); } else { EmployeeSetup objEmployeeSetup = new EmployeeSetup(); objEmployeeSetup.CompanyID = LoginUserInformation.CompanyID; objEmployeeSetup.EmployeeID = LoginUserInformation.EmployeeCode; table = _objUserPermissionController.GetData(objEmployeeSetup); } DataView view = new DataView(table); view.RowFilter = "PNodeTypeID = 111"; foreach (DataRowView row in view) { MenuItem menuItem = new MenuItem(row["ActivityName"].ToString(), row["NodeTypeID"].ToString()); menuItem.NavigateUrl = row["FormName"].ToString(); NavigationMenu.Items.Add(menuItem); AddChildItems(table, menuItem); } } catch (Exception msgException) { throw msgException; } }
public ActionResult Register(HttpPostedFileBase image, EmployeeSetup account) { account.sEmp_empname = account.sEmp_empname; return(Json("")); }
private void SendSecurityCodeByMail(CompanySetup objCompanySetup, UserSecurityCode objUserSecurityCode) { try { objUserSecurityCode.SecurityCode = GetSecurityCode(objCompanySetup, objUserSecurityCode); if (objUserSecurityCode.SecurityCode != 0) { MailServiceSetup objMailServiceSetup = new MailServiceSetup(); objMailServiceSetup.MailBody = "Your security code is: " + objUserSecurityCode.SecurityCode + ""; EmployeeInformationController objEmployeeInformationController = new EmployeeInformationController(); EmployeeSetup objEmployeeSetup = new EmployeeSetup(); objEmployeeSetup.EmployeeID = objUserSecurityCode.UserKnownID; objEmployeeSetup.CompanyID = objCompanySetup.CompanyID; objMailServiceSetup.EmailTo = objEmployeeInformationController.GetEmployeeEmail(objEmployeeSetup); objMailServiceSetup.MailtypeID = "1"; ArrayList attachDocument = new ArrayList(); objMailServiceSetup.AttachItem = attachDocument; MailServiceController objMailServiceController = new MailServiceController(); objMailServiceController.eMailSendService(objCompanySetup, objMailServiceSetup); } } catch (Exception msgException) { throw msgException; } }
private void ShowsysTwoColumnTables() { try { _objTwoColumnTables = new TwoColumnTables(); _objTwoColumnTables.RelatedUserRoleID = Convert.ToInt32(Session["relatedUserRoleID"].ToString()); _objTwoColumnTables.EntrySystem = "A"; EmployeeSetup objEmployeeSetup = new EmployeeSetup(); objEmployeeSetup.CompanyID = LoginUserInformation.CompanyID; objEmployeeSetup.EmployeeID = LoginUserInformation.EmployeeCode; _objTwoColumnTablesController = new TwoColumnTablesController(); DataTable dtTablesName = _objTwoColumnTablesController.GetRecord(_connectionString, _objTwoColumnTables, objEmployeeSetup); grdTableName.DataSource = null; grdTableName.DataBind(); if (dtTablesName.Rows.Count > 0) { grdTableName.DataSource = dtTablesName; grdTableName.DataBind(); } } catch (Exception msgException) { throw msgException; } }
internal void UpdateUserRole(EmployeeSetup objEmployeeSetup, UserPermission objUserPermission) { try { if (objEmployeeSetup.EmployeeID == null) { throw new Exception("User code is required "); } if (objUserPermission.RoleType == null) { throw new Exception("Role type is required "); } string storedProcedureComandTextNode = @" UPDATE [uUsersInRoles] SET [DataUsed] = 'I' ,[LastUpdateDate] = CAST(GETDATE() AS DateTime) ,[LastUpdateUserID] = '" + objEmployeeSetup.EntryUserName + "'" + " WHERE [CompanyID] = " + objEmployeeSetup.CompanyID + " AND [UserId] = '" + objEmployeeSetup.EmployeeID + "'" + " AND [RoleTypeID] = '" + objUserPermission.RoleType + "'"; storedProcedureComandTextNode += @"; UPDATE [uUsersInRelatedRoles] SET [DataUsed] = 'I' ,[LastUpdateDate] = CAST(GETDATE() AS DateTime) ,[LastUpdateUserID] = '" + objEmployeeSetup.EntryUserName + "'" + " WHERE [CompanyID] = " + objEmployeeSetup.CompanyID + " AND [UserId] = '" + objEmployeeSetup.EmployeeID + "'"; clsDataManipulation.StoredProcedureExecuteNonQuery(this.ConnectionString, storedProcedureComandTextNode); this.SaveUserRole(objEmployeeSetup, objUserPermission); } catch (Exception msgException) { throw msgException; } }
private void LoadUserRoleRecord() { try { EmployeeSetup objEmployeeSetup = new EmployeeSetup(); objEmployeeSetup.CompanyID = LoginUserInformation.CompanyID; objEmployeeSetup.EmployeeID = txtUserCode.Text == string.Empty ? null : txtUserCode.Text; _objUserPermission = new UserPermission(); _objUserPermission.RoleType = ddlRoleTypeUser.SelectedValue; _objUserPermissionController = new UserPermissionController(); _objUserPermissionController.GetUserRoleRecord(objEmployeeSetup, _objUserPermission, ListBoxSelectedRoles); _objUserPermissionController.GetRelatedUserRoleRecord(objEmployeeSetup, ListBoxSelectedRelatedUserRole); if (ListBoxSelectedRoles.Items.Count > 0) { btnSave.Text = "Update"; } else { btnSave.Text = "Save"; } } catch (Exception msgException) { throw msgException; } }
private void AddValuesOrganizationalChart(Button btnAction) { try { _objOrganizationalChartSetup = new OrganizationalChartSetup(); _objOrganizationalChartSetup.CompanyID = Convert.ToInt32(ddlCompanyChart.SelectedValue); _objOrganizationalChartSetup.EntityTypeID = Convert.ToInt32(ddlElement.SelectedValue); _objOrganizationalChartSetup.TableName = ddlElement.SelectedValue == "-1" ? null : ddlElement.SelectedItem.Text; _objOrganizationalChartSetup.EntityName = txtTitle.Text == string.Empty ? null : txtTitle.Text; _objOrganizationalChartSetup.ParentEntityID = Convert.ToInt32(lblParentElementValue.Text); _objOrganizationalChartSetup.ShortName = txtShortName.Text == string.Empty ? null : txtShortName.Text; _objOrganizationalChartSetup.DisplayName = txtDisplayName.Text == string.Empty ? null : txtDisplayName.Text; _objOrganizationalChartSetup.GroupEmailAddress = txtEmail.Text == string.Empty ? null : txtEmail.Text; EmployeeSetup objEmployeeSetup = new EmployeeSetup(); objEmployeeSetup.EmployeeID = txtHeadID.Text == string.Empty ? null : txtHeadID.Text; TwoColumnsTableData objTwoColumnsTableData = new TwoColumnsTableData(); objTwoColumnsTableData.FieldOfID = ddlCategory.SelectedValue == "-1" ? null : ddlCategory.SelectedValue; if (txtOpeningDate.Text != string.Empty) { _objOrganizationalChartSetup.EntityOpeningDate = Convert.ToDateTime(txtOpeningDate.Text); } _objOrganizationalChartSetup.AddressTag = CheckBoxAddress.Checked == true ? "Y" : "N"; if (_objOrganizationalChartSetup.AddressTag == "Y") { var contactNumberValue = txtContactNumber.Text == string.Empty ? null : txtContactNumber.Text; if (contactNumberValue != null) { _objOrganizationalChartSetup.ContactAdreessNumber = Convert.ToInt32(contactNumberValue); } _objOrganizationalChartSetup.DisplayAddress = txtDisplayAddress.Text == string.Empty ? null : txtDisplayAddress.Text; _objOrganizationalChartSetup.DivisionID = ddlDivision.SelectedValue == "-1" ? null : ddlDivision.SelectedValue; _objOrganizationalChartSetup.DistrictID = ddlDistrict.SelectedValue == "-1" ? null : ddlDistrict.SelectedValue; _objOrganizationalChartSetup.PostalCode = txtPostalCode.Text == string.Empty ? null : txtPostalCode.Text; _objOrganizationalChartSetup.PhoneNo = txtPhoneNo.Text == string.Empty ? null : txtPhoneNo.Text; _objOrganizationalChartSetup.Fax = txtFax.Text == string.Empty ? null : txtFax.Text; } _objOrganizationalChartSetupController = new OrganizationalChartSetupController(); if (btnAction == btnSaveChart) { _objOrganizationalChartSetupController.SaveChart(_objOrganizationalChartSetup, objEmployeeSetup, objTwoColumnsTableData); } else { _objOrganizationalChartSetupController.UpdateChart(_objOrganizationalChartSetup, objEmployeeSetup, objTwoColumnsTableData); } } catch (Exception msgException) { throw msgException; } }
internal void GetUserRoleRecord(EmployeeSetup objEmployeeSetup, UserPermission objUserPermission, ListBox targetListBox) { try { ClsListBoxController.LoadListBox(this.ConnectionString, this.SQLGetUserRoleRecord(objEmployeeSetup, objUserPermission), targetListBox, "RoleName", "RoleID"); } catch (Exception msgException) { throw msgException; } }
internal void GetRelatedUserRoleRecord(EmployeeSetup objEmployeeSetup, ListBox targetListBox) { try { ClsListBoxController.LoadListBox(this.ConnectionString, this.SQLGetRelatedUserRoleRecord(objEmployeeSetup), targetListBox, "RelatedToText", "RoleID"); } catch (Exception msgException) { throw msgException; } }
internal void SaveUserRole(EmployeeSetup objEmployeeSetup, UserPermission objUserPermission) { try { if (objEmployeeSetup.EmployeeID == null) { throw new Exception("User code is required "); } if (objUserPermission.RoleType == null) { throw new Exception("Role type is required "); } string storedProcedureComandTextNode = null; foreach (var itemNo in objUserPermission.roleList) { objUserPermission.RoleID = itemNo; storedProcedureComandTextNode += @" INSERT INTO [uUsersInRoles] ([CompanyID],[UserId],[RoleTypeID],[RoleID],[DataUsed],[EntryUserID],[EntryDate]) VALUES(" + objEmployeeSetup.CompanyID + ",'" + objEmployeeSetup.EmployeeID + "','" + objUserPermission.RoleType + "'," + objUserPermission.RoleID + ",'" + "A" + "','" + objEmployeeSetup.EntryUserName + "'," + "CAST(GETDATE() AS DateTime)" + ");"; } if (storedProcedureComandTextNode != null) { foreach (var itemNo in objUserPermission.RelatedUserRoleList) { TwoColumnTables objTwoColumnTables = new TwoColumnTables(); objTwoColumnTables.RelatedUserRoleID = itemNo; storedProcedureComandTextNode += @"INSERT INTO [uUsersInRelatedRoles] ([CompanyID],[UserId],[RoleID],[DataUsed],[EntryUserID],[EntryDate]) VALUES(" + objEmployeeSetup.CompanyID + ",'" + objEmployeeSetup.EmployeeID + "'," + objTwoColumnTables.RelatedUserRoleID + ",'" + "A" + "','" + objEmployeeSetup.EntryUserName + "'," + "CAST(GETDATE() AS DateTime)" + ");"; } clsDataManipulation.StoredProcedureExecuteNonQuery(this.ConnectionString, storedProcedureComandTextNode); } } catch (Exception msgException) { throw msgException; } }
internal string GetEmployeeEmail(EmployeeSetup objEmployeeSetup) { try { string sql = " SELECT [Email] FROM [hrEmployeeSetup] WHERE CompanyID = " + objEmployeeSetup.CompanyID + " AND DataUsed ='A' AND EmployeeID = '" + objEmployeeSetup.EmployeeID + "'"; EmployeeDetailsSetup objEmployeeDetailsSetup = new EmployeeDetailsSetup(); clsDataManipulation objclsDataManipulation = new clsDataManipulation(); return(objEmployeeDetailsSetup.Email = objclsDataManipulation.GetSingleValueAsString(this.ConnectionString, sql)); } catch (Exception msgException) { throw msgException; } }
private string SQLGetRelatedUserRoleRecord(EmployeeSetup objEmployeeSetup) { try { string sqlString = null; sqlString = @"SELECT DISTINCT A.[RoleID],B.RelatedToText FROM [uUsersInRelatedRoles] A INNER JOIN sysRelatedUserRole B ON A.CompanyID = B.CompanyID AND A.RoleID = B.RelatedToID WHERE A.DataUsed = 'A' AND A.[CompanyID] = " + objEmployeeSetup.CompanyID + " AND A.UserId = '" + objEmployeeSetup.EmployeeID + "'" + " ORDER BY B.RelatedToText"; return(sqlString); } catch (Exception msgException) { throw msgException; } }
public ActionResult InsEmployee(EmployeeSetup frm) { clsSubmitModel oSubmit = new clsSubmitModel(); string sPath = ""; var File = frm.ImageFile; if (File != null) { var sFileName = Path.GetFileName(File.FileName); var sExt = Path.GetExtension(File.FileName); var sFileNameWithoutExt = Path.GetFileNameWithoutExtension(File.FileName); sPath = Server.MapPath("~/UploadImg/" + File.FileName); File.SaveAs(sPath); //sPath = ("~/UploadImg/" + File.FileName); For Set Image From JavaScript sPath = ("../UploadImg/" + File.FileName); } else if (frm.sPath != null && frm.sPath.ToString() != "") { sPath = frm.sPath; } frm.IMG_Path = sPath; DataTable dt; if (frm.isEdit != true) { dt = oSubmit.GetData("select isnull(max(empcode),0)+1 empcode from employee", true); frm.iEmp_empcode = Convert.ToInt32(dt.Rows[0]["empcode"]); } if (frm.dEAcc_BirthDts != null && frm.dEAcc_BirthDts.ToString() != "") { frm.dEAcc_BirthDt = oSubmit.GetDateFormat(frm.dEAcc_BirthDts); } oSubmit.InsEmployee(frm); dt = oSubmit.GetData("select isnull(max(empcode),0)+1 empcode from employee", true); frm.iEmp_empcode = Convert.ToInt32(dt.Rows[0]["empcode"]); ViewBag.vbImgPath = "../../img/avatar.png"; frm.isEdit = false; return(Json(dt.Rows[0]["empcode"], JsonRequestBehavior.AllowGet)); // return Json(1, JsonRequestBehavior.AllowGet); }
public ActionResult EmployeeSetup(int empCode = 0) { //CRM.Models.clsSubmitModel oSubmit = new CRM.Models.clsSubmitModel(); EmployeeSetup frm = new EmployeeSetup(); var vwDept = from a in db.studdets where a.studType == 11 orderby a.studName select new { itgpName = a.studName, itgpcode = a.studCode }; ViewBag.mstDept = new SelectList(vwDept, "itgpcode", "itgpName"); var vwDesi = from a in db.studdets where a.studType == 1233 orderby a.studName select new { itgpName = a.studName, itgpcode = a.studCode }; ViewBag.iEAcc_empodesg = new SelectList(vwDesi, "itgpcode", "itgpName"); var vwState = from a in db.citydets where a.cityType == 67 && a.cityrute == 3 select new { a.citycode, a.cityname }; ViewBag.vwState = new SelectList(vwState, "citycode", "cityname"); ViewBag.vwBank = new SelectList(from a in db.studdets where a.studType == 163 select new { a.studCode, a.studName }, "studCode", "studName"); if (empCode > 0) { frm = oSubmit.GetEmployeeDet("select empCode iEmp_empcode , empname sEmp_empname, PAN sEmp_PAN, Gender iEmp_Gender, ProofNo sEmp_ProofNo, AcNo sEmp_AcNo, Official_No sOfficial_No,Residential_No sResidential_No,ReferenceNm sReferenceNm , ReferenceNo sReferenceNo,FatherNo sFatherNo, TemporaryAdd sTemporaryAdd, PermanentAdd sPermanentAdd,EmailID sEmailID ,BirthDt dEAcc_BirthDt ,Father ,Aadhar ,IFSC ,DegreeNM ,DegreeID ,empcity iEmp_empcity ,empStat sEmp_empstat ,BloodGroup sBloodGroup ,PfAcNo ,BankID ,empDepa mstDept,empDesi iEAcc_empodesg , IMG_Path sPath, IMG_Path ,AadharCard , VoterId , Licence , Passport , Statement , Degree from employee where empcode = " + empCode); if (frm.IMG_Path != null && frm.IMG_Path.ToString() != "") { ViewBag.vbImgPath = frm.IMG_Path; } else { ViewBag.vbImgPath = "../../img/avatar.png"; } frm.dEAcc_BirthDts = Convert.ToDateTime(frm.dEAcc_BirthDt).ToString("dd/MM/yyyy"); frm.isEdit = true; } else { DataTable dt; dt = oSubmit.GetData("select isnull(max(empcode),0)+1 empcode from employee", true); frm.iEmp_empcode = Convert.ToInt32(dt.Rows[0]["empcode"]); ViewBag.vbImgPath = "../../img/avatar.png"; frm.isEdit = false; } //frm.lstEmployeeSetup = oSubmit.EmployeeList("select empCode iEmp_empcode , empname sEmp_empname, PAN sEmp_PAN, Gender iEmp_Gender, ProofNo sEmp_ProofNo, AcNo sEmp_AcNo, Official_No sOfficial_No,Residential_No sResidential_No,ReferenceNm sReferenceNm , ReferenceNo sReferenceNo,FatherNo sFatherNo, TemporaryAdd sTemporaryAdd, PermanentAdd sPermanentAdd,EmailID sEmailID from employee"); return(PartialView(frm)); }
internal DataTable GetData(EmployeeSetup objEmployeeSetup) { try { string sqlString = @"SELECT DISTINCT D.[NodeTypeID], D.[ActivityName], D.[FormDescription], D.[FormName],D.[PNodeTypeID] FROM uUsersInRoles A INNER JOIN uRoleSetup B ON A.RoleID = B.RoleID AND A.RoleTypeID = B.RoleTypeID INNER JOIN uRoleSetupDetails C ON B.RoleID = C.RoleID INNER JOIN [uDefaultNodeList] D ON C.NodeID = D.NodeTypeID WHERE A.DataUsed = 'A' AND B.DataUsed = 'A' AND C.DataUsed = 'A' AND D.DataUsed = 'A' AND A.CompanyID = " + objEmployeeSetup.CompanyID + " AND A.UserId = '" + objEmployeeSetup.EmployeeID + "'"; var dtEntityDetails = clsDataManipulation.GetData(this.ConnectionString, sqlString); return(dtEntityDetails); } catch (Exception msgException) { throw msgException; } }
private string SQLGetUserRoleRecord(EmployeeSetup objEmployeeSetup, UserPermission objUserPermission) { try { string sqlString = @" SELECT A.RoleID,B.RoleName FROM uUsersInRoles A INNER JOIN uRoleSetup B ON A.RoleID = B.RoleID WHERE A.[DataUsed] = 'A' AND A.CompanyID = " + objEmployeeSetup.CompanyID + " AND A.UserId = '" + objEmployeeSetup.EmployeeID + "'"; if (objUserPermission.RoleType != "-1") { sqlString += " AND A.[RoleTypeID] = '" + objUserPermission.RoleType + "'"; } sqlString += " ORDER BY B.RoleName"; return(sqlString); } catch (Exception msgException) { throw msgException; } }
private void AddValuesForUserRole() { try { _objUserPermission = new UserPermission(); List <int> listRole = new List <int>(); foreach (ListItem item in ListBoxSelectedRoles.Items) { listRole.Add(Convert.ToInt32(item.Value.ToString())); } _objUserPermission.roleList = listRole; _objUserPermission.RoleType = ddlRoleTypeUser.SelectedValue == "-1" ? null : ddlRoleTypeUser.SelectedValue; EmployeeSetup objEmployeeSetup = new EmployeeSetup(); objEmployeeSetup.EmployeeID = txtUserCode.Text == string.Empty ? null : txtUserCode.Text; objEmployeeSetup.CompanyID = LoginUserInformation.CompanyID; objEmployeeSetup.EntryUserName = LoginUserInformation.UserID; _objUserPermissionController = new UserPermissionController(); List <int> listRelatedUserRole = new List <int>(); foreach (ListItem item in ListBoxSelectedRelatedUserRole.Items) { listRelatedUserRole.Add(Convert.ToInt32(item.Value.ToString())); } _objUserPermission.RelatedUserRoleList = listRelatedUserRole; if (btnSave.Text == "Save") { _objUserPermissionController.SaveUserRole(objEmployeeSetup, _objUserPermission); } else { _objUserPermissionController.UpdateUserRole(objEmployeeSetup, _objUserPermission); } } catch (Exception msgException) { throw msgException; } }
internal void SaveChart(OrganizationalChartSetup objOrganizationalChartSetup, EmployeeSetup objEmployeeSetup, TwoColumnsTableData objTwoColumnsTableData) { try { if (objOrganizationalChartSetup.CompanyID == -1) { throw new Exception("company is required "); } objOrganizationalChartSetup.EntityID = Convert.ToInt32(objOrganizationalChartSetup.EntityTypeID.ToString() + this.GetEntityID(objOrganizationalChartSetup).ToString()); var storedProcedureComandText = @"INSERT INTO [orgOrganizationalChartSetup] ([CompanyID],[ParentEntityID],[EntityID],[EntityTypeID] ,[AddressTag],[AddressID],[EntityName],[ShortName],[DisplayName],[GroupEmailAddress],[HeadID] ,[EntityCategoryID],[EntityOpeningDate],[DataUsed],[EntryUserID],[EntryDate]) VALUES ( " + objOrganizationalChartSetup.CompanyID + "," + objOrganizationalChartSetup.ParentEntityID + "," + objOrganizationalChartSetup.EntityID + "," + objOrganizationalChartSetup.EntityTypeID + ",'" + objOrganizationalChartSetup.AddressTag + "'," + objOrganizationalChartSetup.EntityID + ",'" + objOrganizationalChartSetup.EntityName + "','" + objOrganizationalChartSetup.ShortName + "','" + objOrganizationalChartSetup.DisplayName + "','" + objOrganizationalChartSetup.GroupEmailAddress + "','" + objEmployeeSetup.EmployeeID + "','" + objTwoColumnsTableData.FieldOfID + "',CONVERT(DATETIME,'" + objOrganizationalChartSetup.EntityOpeningDate + "', 103),'" + "A" + "', '" + "160ea939-7633-46a8-ae49-f661d12abfd5" + "'," + "CAST(GETDATE() AS DateTime));"; if (objOrganizationalChartSetup.AddressTag == "Y") { storedProcedureComandText += SqlSaveAddress(objOrganizationalChartSetup); } storedProcedureComandText += this.SqlCreateView(objOrganizationalChartSetup); clsDataManipulation.StoredProcedureExecuteNonQuery(this.ConnectionString, storedProcedureComandText); } catch (Exception msgException) { throw msgException; } }
internal void UpdateChart(OrganizationalChartSetup objOrganizationalChartSetup, EmployeeSetup objEmployeeSetup, TwoColumnsTableData objTwoColumnsTableData) { try { var storedProcedureComandText = @"UPDATE [orgOrganizationalChartSetup] SET [AddressTag] = '" + objOrganizationalChartSetup.AddressTag + "'," + "[EntityName] = '" + objOrganizationalChartSetup.EntityName + "'," + "[ShortName] = '" + objOrganizationalChartSetup.ShortName + "'," + "[DisplayName] = '" + objOrganizationalChartSetup.DisplayName + "'," + "[GroupEmailAddress] = '" + objOrganizationalChartSetup.GroupEmailAddress + "'," + "[HeadID] = '" + objEmployeeSetup.EmployeeID + "'," + "[EntityCategoryID] = '" + objTwoColumnsTableData.FieldOfID + "'," + "[EntityOpeningDate] = CONVERT(DATETIME,'" + objOrganizationalChartSetup.EntityOpeningDate + "',103)" + "," + "[LastUpdateDate] = CAST(GETDATE() AS DateTime) " + ",[LastUpdateUserID] = '160ea939-7633-46a8-ae49-f661d12abfd5'" + " WHERE [EntityID] = " + objOrganizationalChartSetup.ParentEntityID + ";"; if (objOrganizationalChartSetup.AddressTag == "N") { storedProcedureComandText += SqlInactiveAddressData(objOrganizationalChartSetup); } else if (objOrganizationalChartSetup.AddressTag == "Y") { storedProcedureComandText += SqlUpdateAddress(objOrganizationalChartSetup); } storedProcedureComandText += this.SqlCreateView(objOrganizationalChartSetup); clsDataManipulation.StoredProcedureExecuteNonQuery(this.ConnectionString, storedProcedureComandText); } catch (Exception msgException) { throw msgException; } }
public DataTable GetRecord(string connectionString, TwoColumnTables objTwoColumnTables, EmployeeSetup objEmployeeSetup) { try { DataTable dtItem = null; string sqlString = @"SELECT DISTINCT A.[TableID],A.[TableName],A.[RelatedUserRoleID] FROM [sysTwoColumnTables] A INNER JOIN uUsersInRelatedRoles B ON A.RelatedUserRoleID = B.RoleID WHERE A.DataUsed = 'A' AND B.DataUsed = 'A' AND A.EntrySystem = '" + objTwoColumnTables.EntrySystem + "' AND " + " B.CompanyID = " + objEmployeeSetup.CompanyID + " AND B.UserId = '" + objEmployeeSetup.EmployeeID + "' ORDER BY A.[TableName],A.[RelatedUserRoleID]"; dtItem = clsDataManipulation.GetData(connectionString, sqlString); return(dtItem); } catch (Exception msgException) { throw msgException; } }