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