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