private string SqlSaveAddress(OrganizationalChartSetup objOrganizationalChartSetup) { try { objOrganizationalChartSetup.ContactAddressUsedID = GetContactAdreessNumber(objOrganizationalChartSetup); var storedProcedureComandText = @"INSERT INTO [orgOrganizationAddress] ([EntityAdreessID],[ContactAdreessNumber],[ContactAddressUsedID],[AddressAsOn] ,[DisplayAddress],[DivisionID],[DistrictID],[PostalCode],[ContactPhoneNo],[Fax],[DataUsed],[EntryUserID],[EntryDate]) VALUES ( " + objOrganizationalChartSetup.EntityID + "," + objOrganizationalChartSetup.ContactAdreessNumber + "," + objOrganizationalChartSetup.ContactAddressUsedID + "," + "CAST(GETDATE() AS DateTime)" + ",'" + objOrganizationalChartSetup.DisplayAddress + "'," + objOrganizationalChartSetup.DivisionID + "," + objOrganizationalChartSetup.DistrictID + ",'" + objOrganizationalChartSetup.PostalCode + "','" + objOrganizationalChartSetup.PhoneNo + "','" + objOrganizationalChartSetup.Fax + "','" + "A" + "', '" + "160ea939-7633-46a8-ae49-f661d12abfd5" + "'," + "CAST(GETDATE() AS DateTime));"; return(storedProcedureComandText); } catch (Exception msgException) { throw msgException; } }
internal DataTable GetEntityDetails(OrganizationalChartSetup objOrganizationalChartSetup) { try { var sqlString = @"SELECT A.[CompanyID] ,[EntityTypeID] ,[AddressTag] ,[AddressID] ,[EntityName] ,[ShortName] ,[DisplayName] ,[GroupEmailAddress] ,[HeadID] ,[EntityCategoryID] ,[EntityOpeningDate] FROM [orgOrganizationalChartSetup] A WHERE A.DataUsed = 'A' AND A.EntityID = " + objOrganizationalChartSetup.EntityID + " "; var dtEntityDetails = clsDataManipulation.GetData(this.ConnectionString, sqlString); return(dtEntityDetails); } catch (Exception msgException) { throw msgException; } }
private string SqlCreateView(OrganizationalChartSetup objOrganizationalChartSetup) { try { string sqlForView = null; sqlForView = @" if exists(Select * from sysobjects where name = 'org" + objOrganizationalChartSetup.TableName.Replace(" ", String.Empty) + "' and type = 'V' ) begin drop view org" + objOrganizationalChartSetup.TableName.Replace(" ", String.Empty) + " end;"; sqlForView += " exec('create view org" + objOrganizationalChartSetup.TableName.Replace(" ", string.Empty) + @" as SELECT [CompanyID] ,[ParentEntityID] ,[EntityID] ,[AddressTag] ,[AddressID] ,[EntityName] ,[ShortName] ,[DisplayName] ,[GroupEmailAddress] ,[HeadID] ,[EntityCategoryID] ,[EntityOpeningDate] ,[DataUsed] ,[EntryUserID] ,[EntryDate] ,[LastUpdateDate] ,[LastUpdateUserID] FROM [orgOrganizationalChartSetup] WHERE [EntityTypeID] = " + objOrganizationalChartSetup.EntityTypeID + "');"; return(sqlForView); } catch (Exception msgException) { throw msgException; } }
private void AddOrgElements() { try { _objOrganizationalChartSetup = new OrganizationalChartSetup(); _objOrganizationalChartSetup.CompanyID = Convert.ToInt32(ddlCompany.SelectedValue); List <int> list = new List <int>(); foreach (ListItem item in ListBoxOrganizationElements.Items) { list.Add(Convert.ToInt32(item.Value)); } _objOrganizationalChartSetup.OrgElementIDList = list; _objOrganizationalChartSetupController = new OrganizationalChartSetupController(); if (btnSave.Text == "Save") { _objOrganizationalChartSetupController.Save(_objOrganizationalChartSetup); } else { _objOrganizationalChartSetupController.Update(_objOrganizationalChartSetup); } } catch (Exception msgException) { throw msgException; } }
internal void Save(OrganizationalChartSetup objOrganizationalChartSetup) { try { if (objOrganizationalChartSetup.CompanyID == -1) { throw new Exception(" company name is required "); } if (objOrganizationalChartSetup.OrgElementIDList.Count == 0) { throw new Exception("please select elements correctly"); } foreach (var listItem in objOrganizationalChartSetup.OrgElementIDList) { var storedProcedureComandText = "INSERT INTO [orgOrganizationElements] ([CompanyID],[OrgElementID],[DataUsed],[EntryUserID],[EntryDate]) VALUES ( " + objOrganizationalChartSetup.CompanyID + "," + listItem.ToString() + ",'" + "A" + "', '" + "160ea939-7633-46a8-ae49-f661d12abfd5" + "'," + "CAST(GETDATE() AS DateTime));"; 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 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 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 LoadOrganizationalElementsWithCompany(OrganizationalChartSetup objOrganizationalChartSetup, GridView gridViewOrganizationElements) { try { ClsGridViewLoad.LoadGridView(this.ConnectionString, this.SqlGetOrganizationalElementsWithCompany(objOrganizationalChartSetup), gridViewOrganizationElements); } catch (Exception msgException) { throw msgException; } }
internal void LoadOrganizationalElements(OrganizationalChartSetup objOrganizationalChartSetup, ListBox listBoxOrganizationElements) { try { ClsListBoxController.LoadListBox(this.ConnectionString, SqlGetOrganizationalElements(objOrganizationalChartSetup), listBoxOrganizationElements, "OrgElementName", "OrgElementID"); } catch (Exception msgException) { throw msgException; } }
internal void DeleteChart(OrganizationalChartSetup objOrganizationalChartSetup) { try { var storedProcedureComandText = " UPDATE [orgOrganizationalChartSetup] SET DataUsed = 'I' WHERE [EntityID] = " + objOrganizationalChartSetup.EntityID + ""; clsDataManipulation.StoredProcedureExecuteNonQuery(this.ConnectionString, storedProcedureComandText); } catch (Exception msgException) { throw msgException; } }
internal void LoadOrganizationalElements(OrganizationalChartSetup objOrganizationalChartSetup, DropDownList dropDownListOrganizationElements) { try { ClsDropDownListController.LoadDropDownList(this.ConnectionString, this.SqlGetOrganizationalElements(objOrganizationalChartSetup), dropDownListOrganizationElements, "OrgElementName", "OrgElementID"); } catch (Exception msgException) { throw msgException; } }
private void GetOrganizationalElements(string companyID, ListBox ListBoxOrganizationElements) { try { _objOrganizationalChartSetup = new OrganizationalChartSetup(); _objOrganizationalChartSetup.CompanyID = Convert.ToInt32(companyID); _objOrganizationalChartSetupController = new OrganizationalChartSetupController(); _objOrganizationalChartSetupController.LoadOrganizationalElements(_objOrganizationalChartSetup, ListBoxOrganizationElements); } catch (Exception msgException) { throw msgException; } }
internal void LoadCategory(OrganizationalChartSetup objOrganizationalChartSetup, DropDownList ddlCategory) { try { TwoColumnsTableDataController objTwoColumnsTableDataController = new TwoColumnsTableDataController(); TwoColumnsTableData objTwoColumnsTableData = new TwoColumnsTableData(); objTwoColumnsTableData.TableID = objOrganizationalChartSetup.EntityTypeID; objTwoColumnsTableDataController.LoadCategory(objTwoColumnsTableData, ddlCategory); } catch (Exception msgException) { throw msgException; } }
private void DeleteCompanyChart(CompanyDetailsSetup objCompanyDetailsSetup) { try { _objOrganizationalChartSetup = new OrganizationalChartSetup(); _objOrganizationalChartSetup.EntityID = objCompanyDetailsSetup.CompanyID; _objOrganizationalChartSetupController = new OrganizationalChartSetupController(); _objOrganizationalChartSetupController.DeleteChart(_objOrganizationalChartSetup); } catch (Exception msgException) { throw msgException; } }
internal int GetEntityTypeID(OrganizationalChartSetup objOrganizationalChartSetup) { try { var sqlString = "SELECT [EntityTypeID] FROM [orgOrganizationalChartSetup] WHERE [EntityID] = " + objOrganizationalChartSetup.EntityID + ""; clsDataManipulation objclsDataManipulation = new clsDataManipulation(); var entityTypeID = objclsDataManipulation.GetSingleValue(this.ConnectionString, sqlString); return(entityTypeID); } catch (Exception msgException) { throw msgException; } }
private void UCGetOrganizationElements() { try { _objOrganizationalChartSetup = new OrganizationalChartSetup(); _objOrganizationalChartSetup.CompanyID = LoginUserInformation.CompanyID; _objUCOrganizationalChartController = new UCOrganizationalChartController(); _objUCOrganizationalChartController.GetOrganizationElementsGV(GridViewOrganizationalChart, _objOrganizationalChartSetup); } catch (Exception msgException) { throw msgException; } }
protected void TreeViewCompanyChart_SelectedNodeChanged(object sender, EventArgs e) { try { lblParentElementText.Text = TreeViewCompanyChart.SelectedNode.Text; lblParentElementText.Visible = true; _objOrganizationalChartSetup = new OrganizationalChartSetup(); _objOrganizationalChartSetup.EntityID = Convert.ToInt32(TreeViewCompanyChart.SelectedNode.Value); lblParentElementValue.Text = _objOrganizationalChartSetup.EntityID.ToString(); txtTitle.Focus(); _objOrganizationalChartSetupController = new OrganizationalChartSetupController(); _objOrganizationalChartSetup.EntityTypeID = _objOrganizationalChartSetupController.GetEntityTypeID(_objOrganizationalChartSetup); _objOrganizationalChartSetupController.LoadDivisionDDL(ddlDivision); _objOrganizationalChartSetupController.LoadDistrict(ddlDistrict); btnSaveChart.Visible = true; btnUpdate.Visible = true; if (Convert.ToInt32(_objOrganizationalChartSetup.EntityID) == 111) { btnSaveChart.Visible = false; btnUpdate.Visible = false; } else if (_objOrganizationalChartSetup.EntityTypeID == 1) { btnUpdate.Visible = false; ddlCompanyChart.SelectedValue = _objOrganizationalChartSetup.EntityID.ToString(); _objOrganizationalChartSetup.CompanyID = Convert.ToInt32(ddlCompanyChart.SelectedValue); _objOrganizationalChartSetupController.LoadOrganizationalElements(_objOrganizationalChartSetup, ddlElement); } else { ViewEntityDetails(_objOrganizationalChartSetup); if (CheckBoxAddress.Checked == true) { _objOrganizationalChartSetup = new OrganizationalChartSetup(); _objOrganizationalChartSetup.EntityID = Convert.ToInt32(TreeViewCompanyChart.SelectedNode.Value); ViewEntityAddress(_objOrganizationalChartSetup); PanelAddress.Visible = true; } else { ClearChartAddressControl(); } } } catch (Exception msgException) { clsTopMostMessageBox.Show(msgException.Message); } }
private string SqlGetOrganizationalElements(OrganizationalChartSetup objOrganizationalChartSetup) { try { string sqlQuery = null; sqlQuery = @"SELECT A.[OrgElementID],B.OrgElementName FROM [orgOrganizationElements] A INNER JOIN orgStandardOrgElements B ON A.OrgElementID = B.OrgElementID WHERE A.[DataUsed] = 'A' AND A.[CompanyID]= " + objOrganizationalChartSetup.CompanyID + " ORDER BY B.HierarchyID"; return(sqlQuery); } catch (Exception msgException) { throw msgException; } }
private string SqlInactiveAddressData(OrganizationalChartSetup objOrganizationalChartSetup) { try { var storedProcedureComandText = @" UPDATE [orgOrganizationAddress] SET [DataUsed] = 'I' ,[LastUpdateDate] = CAST(GETDATE() AS DateTime) ,[LastUpdateUserID] = '160ea939-7633-46a8-ae49-f661d12abfd5' WHERE [DataUsed] = 'A' AND [EntityAdreessID] = " + objOrganizationalChartSetup.ParentEntityID + " ;"; return(storedProcedureComandText); } catch (Exception msgException) { throw msgException; } }
internal void UpdateChart(OrganizationalChartSetup objOrganizationalChartSetup) { try { var storedProcedureComandText = @"UPDATE [orgOrganizationalChartSetup] SET [EntityName] = '" + objOrganizationalChartSetup.EntityName + "'," + "[DataUsed] = 'A' ," + "[LastUpdateDate] = CAST(GETDATE() AS DateTime) " + ",[LastUpdateUserID] = '" + objOrganizationalChartSetup.EntryUserName + "'" + " WHERE [EntityID] = " + objOrganizationalChartSetup.EntityID + ";"; clsDataManipulation.StoredProcedureExecuteNonQuery(this.ConnectionString, storedProcedureComandText); } catch (Exception msgException) { throw msgException; } }
private void UpdateCompanyChart(CompanyDetailsSetup objCompanyDetailsSetup) { try { _objOrganizationalChartSetup = new OrganizationalChartSetup(); objCompanyDetailsSetup.EntryUserName = "******"; _objOrganizationalChartSetup.EntityID = objCompanyDetailsSetup.CompanyID; _objOrganizationalChartSetup.EntityName = objCompanyDetailsSetup.CompanyName; _objOrganizationalChartSetup.EntryUserName = objCompanyDetailsSetup.EntryUserName; _objOrganizationalChartSetupController = new OrganizationalChartSetupController(); _objOrganizationalChartSetupController.UpdateChart(_objOrganizationalChartSetup); } catch (Exception msgException) { throw msgException; } }
private int GetContactAdreessNumber(OrganizationalChartSetup objOrganizationalChartSetup) { try { int seqNo = 0; var storedProcedureComandText = @" SELECT ISNULL( MAX([ContactAddressUsedID]),0)+1 FROM [orgOrganizationAddress] WHERE [EntityAdreessID] = " + objOrganizationalChartSetup.EntityID + ""; var dtSeq = clsDataManipulation.GetData(this.ConnectionString, storedProcedureComandText); foreach (DataRow item in dtSeq.Rows) { seqNo = Convert.ToInt32(item.ItemArray[0].ToString()); } return(seqNo); } 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 DataTable GetEntityAddress(OrganizationalChartSetup objOrganizationalChartSetup) { try { var sqlString = @"SELECT [ContactAdreessNumber] ,[DisplayAddress] ,[DivisionID] ,[DistrictID] ,[PostalCode] ,[ContactPhoneNo] ,[Fax] FROM [orgOrganizationAddress] WHERE [DataUsed] = 'A' AND [EntityAdreessID] = " + objOrganizationalChartSetup.EntityID + ""; var dtEntityDetails = clsDataManipulation.GetData(this.ConnectionString, sqlString); return(dtEntityDetails); } catch (Exception msgException) { throw msgException; } }
public string GetEntityID(OrganizationalChartSetup objOrganizationalChartSetup) { try { string seqNo = null; var storedProcedureComandText = @" DECLARE @RefNumber VARCHAR(10),@countData INT SET @countData = ( SELECT ISNULL( COUNT( EntityID),0) +1 FROM orgOrganizationalChartSetup WHERE EntityTypeID = " + objOrganizationalChartSetup.EntityTypeID + ") " + " SET @RefNumber=STUFF('00',3-LEN(@countData),20,@countData) ; SELECT @RefNumber"; var dtSeq = clsDataManipulation.GetData(this.ConnectionString, storedProcedureComandText); foreach (DataRow item in dtSeq.Rows) { seqNo = item.ItemArray[0].ToString(); } return(seqNo); } catch (Exception msgException) { throw msgException; } }
protected void ddlElement_SelectedIndexChanged(object sender, EventArgs e) { try { _objOrganizationalChartSetup = new OrganizationalChartSetup(); _objOrganizationalChartSetup.EntityTypeID = Convert.ToInt32(ddlElement.SelectedValue); if (_objOrganizationalChartSetup.EntityTypeID == -1) { ddlCategory.Items.Clear(); } else { _objOrganizationalChartSetupController = new OrganizationalChartSetupController(); _objOrganizationalChartSetupController.LoadCategory(_objOrganizationalChartSetup, ddlCategory); } } catch (Exception msgExecption) { clsTopMostMessageBox.Show(msgExecption.Message); } }
private void SaveCompanyChart(CompanyDetailsSetup objCompanyDetailsSetup) { try { _objOrganizationalChartSetup = new OrganizationalChartSetup(); objCompanyDetailsSetup.EntryUserName = "******"; _objOrganizationalChartSetup.CompanyID = objCompanyDetailsSetup.CompanyID; _objOrganizationalChartSetup.ParentEntityID = 111; _objOrganizationalChartSetup.EntityID = objCompanyDetailsSetup.CompanyID; _objOrganizationalChartSetup.AddressTag = "N"; _objOrganizationalChartSetup.AddressID = objCompanyDetailsSetup.CompanyID; _objOrganizationalChartSetup.EntityName = objCompanyDetailsSetup.CompanyName; _objOrganizationalChartSetup.EntityTypeID = 1; _objOrganizationalChartSetup.EntryUserName = objCompanyDetailsSetup.EntryUserName; _objOrganizationalChartSetupController = new OrganizationalChartSetupController(); _objOrganizationalChartSetupController.SaveChart(_objOrganizationalChartSetup); } catch (Exception msgException) { throw msgException; } }
private string SqlUpdateAddress(OrganizationalChartSetup objOrganizationalChartSetup) { try { var storedProcedureComandText = @"UPDATE [orgOrganizationAddress] SET [ContactAdreessNumber] = " + objOrganizationalChartSetup.ContactAdreessNumber + " " + " ,[DisplayAddress] = '" + objOrganizationalChartSetup.DisplayAddress + "'" + " ,[DivisionID] = " + objOrganizationalChartSetup.DivisionID + " " + " ,[DistrictID] = " + objOrganizationalChartSetup.DistrictID + " " + " ,[PostalCode] = '" + objOrganizationalChartSetup.PostalCode + "'" + " ,[ContactPhoneNo] = '" + objOrganizationalChartSetup.PhoneNo + "'" + " ,[Fax] = '" + objOrganizationalChartSetup.Fax + "'" + " ,[LastUpdateDate] = CAST(GETDATE() AS DateTime)" + " ,[LastUpdateUserID] = '160ea939-7633-46a8-ae49-f661d12abfd5'" + " WHERE [DataUsed] = 'A' AND [EntityAdreessID] = " + objOrganizationalChartSetup.ParentEntityID + ";"; return(storedProcedureComandText); } catch (Exception msgException) { throw msgException; } }
internal void SaveChart(OrganizationalChartSetup objOrganizationalChartSetup) { try { var storedProcedureComandText = @"INSERT INTO [orgOrganizationalChartSetup] ([CompanyID],[ParentEntityID],[EntityID],[EntityTypeID] ,[AddressTag],[AddressID],[EntityName],[DataUsed],[EntryUserID],[EntryDate]) VALUES ( " + objOrganizationalChartSetup.CompanyID + "," + objOrganizationalChartSetup.ParentEntityID + "," + objOrganizationalChartSetup.EntityID + "," + objOrganizationalChartSetup.EntityTypeID + ",'" + objOrganizationalChartSetup.AddressTag + "'," + objOrganizationalChartSetup.EntityID + ",'" + objOrganizationalChartSetup.EntityName + "','" + "A" + "', '" + objOrganizationalChartSetup.EntryUserName + "'," + "CAST(GETDATE() AS DateTime));"; clsDataManipulation.StoredProcedureExecuteNonQuery(this.ConnectionString, storedProcedureComandText); } catch (Exception msgException) { throw msgException; } }