private void AddValues() { try { _objEmployeeDetailsSetup = new EmployeeDetailsSetup(); _objEmployeeDetailsSetup.CompanyID = this.OrganizationalChartControl1.empCompany; _objEmployeeDetailsSetup.dtEmployeeChart = this.OrganizationalChartControl1.empValueAsTable; _objEmployeeDetailsSetup.EmployeeID = txtEmployeeID.Text == string.Empty ? null : txtEmployeeID.Text; _objEmployeeTypeSetup = new EmployeeTypeSetup(); _objEmployeeTypeSetup.EmployeeTypeID = Convert.ToInt32(ddlEmployeeType.SelectedValue); _objEmployeeCategorySetup = new EmployeeCategorySetup(); _objEmployeeCategorySetup.EmployeeCategoryID = Convert.ToInt32(ddlEmployeeCategory.SelectedValue); _objEmployeeDetailsSetup.EmployeeTitle = Convert.ToInt32(ddlTitle.SelectedValue); _objDesignationSetup = new DesignationSetup(); _objDesignationSetup.DesignationID = ddlDesignationEmployee.SelectedValue; _objEmployeeDetailsSetup.FirstName = txtFirstName.Text == string.Empty ? null : txtFirstName.Text; _objEmployeeDetailsSetup.MiddleName = txtMiddleName.Text == string.Empty ? null : txtMiddleName.Text; _objEmployeeDetailsSetup.LastName = txtLastName.Text == string.Empty ? null : txtLastName.Text; _objEmployeeDetailsSetup.Email = txtEmail.Text == string.Empty ? null : txtEmail.Text; _objEmployeeDetailsSetup.EntryUserName = LoginUserInformation.UserID; IsUser objIsUser = new IsUser(); objIsUser.UserPermission = Convert.ToInt32(ddlUserPermission.SelectedValue); _objEmployeeSetupController = new EmployeeSetupController(); _objEmployeeSetupController.Save(_objEmployeeDetailsSetup, _objEmployeeTypeSetup, _objEmployeeCategorySetup, _objDesignationSetup, objIsUser); } catch (Exception msgException) { throw msgException; } }
public void Save(EmployeeDetailsSetup objEmployeeDetailsSetup, EmployeeTypeSetup objEmployeeTypeSetup, EmployeeCategorySetup objEmployeeCategorySetup, DesignationSetup objDesignationSetup, IsUser objIsUser) { try { objEmployeeDetailsSetup.EmployeeSerialNo = this.GetEmployeeSerialNo(); var storedProcedureComandText = "INSERT INTO [hrEmployeeSetup] ([ReferenceID],[CompanyID],[EmployeeID],[EmployeeTypeID], " + " [EmployeeCategoryID] ,[Title],[FirstName],[MiddleName],[LastName],[Email],[UserPermission] ,[DataUsed],[EntryUserID],[EntryDate]) VALUES ( " + objEmployeeDetailsSetup.EmployeeSerialNo + "," + objEmployeeDetailsSetup.CompanyID + ",'" + objEmployeeDetailsSetup.EmployeeID + "', " + objEmployeeTypeSetup.EmployeeTypeID + ", " + objEmployeeCategorySetup.EmployeeCategoryID + ", '" + objEmployeeDetailsSetup.EmployeeTitle + "', '" + objEmployeeDetailsSetup.FirstName + "', '" + objEmployeeDetailsSetup.MiddleName + "', '" + objEmployeeDetailsSetup.LastName + "', '" + objEmployeeDetailsSetup.Email + "'," + objIsUser.UserPermission + ",'" + "A" + "', '" + objEmployeeDetailsSetup.EntryUserName + "'," + "CAST(GETDATE() AS DateTime));"; clsDataManipulation.StoredProcedureExecuteNonQuery(this.ConnectionString, storedProcedureComandText); objDesignationSetup.LastPositionNo = this.GetLastPosition(objEmployeeDetailsSetup); var storedProcedureComandTextDesignation = "INSERT INTO [empDesignation]([ReferenceID],[DesignationID],[LastPosition],[DataUsed],[EntryUserID],[EntryDate]) VALUES( " + objEmployeeDetailsSetup.EmployeeSerialNo + ",'" + objDesignationSetup.DesignationID + "'," + objDesignationSetup.LastPositionNo + ",'" + "A" + "','" + objEmployeeDetailsSetup.EntryUserName + "'," + "CAST(GETDATE() AS DateTime));"; clsDataManipulation.StoredProcedureExecuteNonQuery(this.ConnectionString, storedProcedureComandTextDesignation); string storedProcedureComandTextChart = null; foreach (DataRow rowNo in objEmployeeDetailsSetup.dtEmployeeChart.Rows) { OrganizationalChartSetup objOrganizationalChartSetup = new OrganizationalChartSetup(); objOrganizationalChartSetup.EntityTypeID = Convert.ToInt32(rowNo["EntityTypeID"].ToString()); objOrganizationalChartSetup.EntityID = Convert.ToInt32(rowNo["EntityID"].ToString()); storedProcedureComandTextChart += "INSERT INTO [orgEmployeeChart] ([ReferenceID],[EntityTypeID],[EntityID],[LastPosition],[DataUsed],[EntryUserID],[EntryDate] " + ") VALUES( " + objEmployeeDetailsSetup.EmployeeSerialNo + "," + objOrganizationalChartSetup.EntityTypeID + "," + objOrganizationalChartSetup.EntityID + "," + objDesignationSetup.LastPositionNo + ",'" + "A" + "','" + objEmployeeDetailsSetup.EntryUserName + "'," + "CAST(GETDATE() AS DateTime));"; } if (storedProcedureComandTextChart != null) { clsDataManipulation.StoredProcedureExecuteNonQuery(this.ConnectionString, storedProcedureComandTextChart); } } catch (Exception msgException) { throw msgException; } }
private void LoadEmployeeCategory() { try { _objEmployeeDetailsSetup = new EmployeeDetailsSetup(); _objEmployeeDetailsSetup.CompanyID = LoginUserInformation.CompanyID; _objEmployeeSetupController.GetEmployeeCategory(ddlEmployeeCategory, _objEmployeeDetailsSetup); } catch (Exception msgException) { throw msgException; } }
private int GetLastPosition(EmployeeDetailsSetup objEmployeeDetailsSetup) { try { int lastPositionNo = 0; var storedProcedureComandText = "SELECT ISNULL( MAX( [LastPosition]),0) +1 FROM [empDesignation] WHERE [ReferenceID]= " + objEmployeeDetailsSetup.EmployeeSerialNo + " "; lastPositionNo = clsDataManipulation.GetMaximumValueUsingSQL(this.ConnectionString, storedProcedureComandText); return(lastPositionNo); } catch (Exception msgException) { throw msgException; } }
internal void GetEmployeeCategory(DropDownList ddlEmployeeCategory, EmployeeDetailsSetup objEmployeeDetailsSetup) { try { _objTwoColumnsTableData = new TwoColumnsTableData(); _objTwoColumnsTableData.CompanyID = objEmployeeDetailsSetup.CompanyID; _objTwoColumnsTableDataController = new TwoColumnsTableDataController(); _objTwoColumnsTableDataController.LoadEmployeeCategoryDDL(ddlEmployeeCategory, _objTwoColumnsTableData); } 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; } }