public JsonResult GetDdlData(int Id, int Operation)
{
Dictionary <string, string> outData = new Dictionary <string, string>();
NuPortalDBService.NuPortalService dbService = new NuPortalDBService.NuPortalService();
dbService.Url = Constants.DBService;
try
{
string jsonData = dbService.GetDDListBox(Id, Operation);
if (jsonData != "")
{
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
GeneralFunctions genFun = new GeneralFunctions();
genFun.LogError(ControllerContext.HttpContext, ex.Message, ex.TargetSite.Name,
Convert.ToString(ControllerContext.RouteData.Values["action"]),
Convert.ToString(ControllerContext.RouteData.Values["controller"]));
genFun = null;
outData = new Dictionary <string, string>();
outData.Add("Error", "Error");
return(Json(JsonConvert.SerializeObject(outData), JsonRequestBehavior.AllowGet));
}
finally
{
dbService = null;
}
outData = new Dictionary <string, string>();
outData.Add("Error", "Error");
return(Json(JsonConvert.SerializeObject(outData), JsonRequestBehavior.AllowGet));
}
public JsonResult getProjectName()
{
NuPortalDBService.NuPortalService dBService = new NuPortalDBService.NuPortalService();
dBService.Url = Constants.DBService;
try
{
string jsonLocation = dBService.GetDDListBox(Convert.ToInt32(Session["EmpID"]), 16);
if (jsonLocation != string.Empty)
{
return(Json(jsonLocation, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
GeneralFunctions genFun = new GeneralFunctions();
genFun.LogError(ControllerContext.HttpContext, ex.Message, ex.TargetSite.Name,
Convert.ToString(ControllerContext.RouteData.Values["action"]),
Convert.ToString(ControllerContext.RouteData.Values["controller"]));
genFun = null;
}
finally
{
dBService = null;
}
return(Json(Common_Library.Constants.JsonError, JsonRequestBehavior.AllowGet));
}
public JsonResult GetReimbursemenType()
{
Dictionary <string, string> outData = new Dictionary <string, string>();
NuPortalDBService.NuPortalService dBService = new NuPortalDBService.NuPortalService();
dBService.Url = Constants.DBService;
try
{
string jsonReim = dBService.GetDDListBox(Convert.ToInt32(Session["CompanyId"]), 9);
if (jsonReim != string.Empty)
{
return(Json(jsonReim, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
GeneralFunctions genFun = new GeneralFunctions();
genFun.LogError(ControllerContext.HttpContext, ex.Message, ex.TargetSite.Name,
Convert.ToString(ControllerContext.RouteData.Values["action"]),
Convert.ToString(ControllerContext.RouteData.Values["controller"]));
genFun = null;
}
finally
{
dBService = null;
}
outData = new Dictionary <string, string>();
outData.Add("Error", "Error");
return(Json(JsonConvert.SerializeObject(outData), JsonRequestBehavior.AllowGet));
}
public JsonResult GetTaskName()
{
Dictionary <string, string> outData = new Dictionary <string, string>();
NuPortalDBService.NuPortalService taskService = new NuPortalDBService.NuPortalService();
taskService.Url = Constants.DBService;
try
{
string jsonTaskName = taskService.GetDDListBox(Convert.ToInt32(Session["CompanyId"]), 12);
if (jsonTaskName != string.Empty)
{
return(Json(jsonTaskName, JsonRequestBehavior.AllowGet));
}
else
{
outData = new Dictionary <string, string>();
outData.Add("Error", "Error");
return(Json(JsonConvert.SerializeObject(outData), JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
outData = new Dictionary <string, string>();
outData.Add("Error", "Error");
return(Json(JsonConvert.SerializeObject(outData), JsonRequestBehavior.AllowGet));
}
finally
{
taskService = null;
}
}
public JsonResult GetContact(int clientId)
{
try
{
NuPortalDBService.NuPortalService dbService = new NuPortalDBService.NuPortalService();
dbService.Url = Constants.DBService;
string ReturnVal = dbService.GetDDListBox(clientId, 6);
if (ReturnVal != string.Empty)
{
return(Json(ReturnVal, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
GeneralFunctions genFun = new GeneralFunctions();
genFun.LogError(ControllerContext.HttpContext, ex.Message, ex.TargetSite.Name,
Convert.ToString(ControllerContext.RouteData.Values["action"]),
Convert.ToString(ControllerContext.RouteData.Values["controller"]));
genFun = null;
}
return(Json(Common_Library.Constants.JsonError, JsonRequestBehavior.AllowGet));
}
public JsonResult BindDropdown(int RowId, int Operation)
{
try
{
NuPortalDBService.NuPortalService dbService = new NuPortalDBService.NuPortalService();
dbService.Url = Constants.DBService;
string jsonString = dbService.GetDDListBox(RowId, Operation);
if (jsonString != string.Empty)
{
return(Json(jsonString, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
GeneralFunctions genFun = new GeneralFunctions();
genFun.LogError(ControllerContext.HttpContext, ex.Message, ex.TargetSite.Name,
Convert.ToString(ControllerContext.RouteData.Values["action"]),
Convert.ToString(ControllerContext.RouteData.Values["controller"]));
genFun = null;
}
return(Json(Common_Library.Constants.JsonError, JsonRequestBehavior.AllowGet));
}
public JsonResult GetTasksList(int EmpId)
{
NuPortalDBService.NuPortalService dbService = new NuPortalDBService.NuPortalService();
dbService.Url = Constants.DBService;
try
{
string JsonString = dbService.GetDDListBox(EmpId == 0 ? Convert.ToInt16(Session["EmpId"]) : EmpId, 19);
if (JsonString != string.Empty)
{
return(Json(JsonString, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
GeneralFunctions genFun = new GeneralFunctions();
genFun.LogError(ControllerContext.HttpContext, ex.Message, ex.TargetSite.Name,
Convert.ToString(ControllerContext.RouteData.Values["action"]),
Convert.ToString(ControllerContext.RouteData.Values["controller"]));
genFun = null;
}
finally { dbService.Dispose(); }
return(Json(Common_Library.Constants.JsonError));
}
public ActionResult EmpInfoAdminView(int?hdnId)
{
List <SelectListItem> items;
NuPortal.Models.EmpInfoAdminView empAdmin = new Models.EmpInfoAdminView();
NuPortalDBService.NuPortalService dbService = new NuPortalDBService.NuPortalService();
NuPortalEmpService.NuPortalEmployeeService empService = new NuPortalEmpService.NuPortalEmployeeService();
dbService.Url = Constants.DBService;
empService.Url = Constants.EmpService;
DataTable dtDesignation = JsonConvert.DeserializeObject <DataTable>(dbService.GetDDListBox(Convert.ToInt32(Session["CompanyId"]), 0));
DataTable dtLocation = JsonConvert.DeserializeObject <DataTable>(dbService.GetDDListBox(Convert.ToInt32(Session["CompanyId"]), 44));
DataTable dtEmploymentType = JsonConvert.DeserializeObject <DataTable>(dbService.GetDDListBox(Convert.ToInt32(Session["CompanyId"]), 2));
DataTable dtStatus = JsonConvert.DeserializeObject <DataTable>(dbService.GetDDListBox(Convert.ToInt32(Session["CompanyId"]), 39));
items = new List <SelectListItem>();
if (dtDesignation != null && dtDesignation.Rows.Count > 0)
{
for (int i = 0; i < dtDesignation.Rows.Count; i++)
{
items.Add(new SelectListItem
{
Text = dtDesignation.Rows[i]["Designation"].ToString(),
Value = dtDesignation.Rows[i]["DesignationId"].ToString()
});
}
}
else
{
items.Add(new SelectListItem
{
Text = "",
Value = ""
});
}
empAdmin.designation = items;
items = new List <SelectListItem>();
if (dtLocation != null && dtLocation.Rows.Count > 0)
{
for (int i = 0; i < dtLocation.Rows.Count; i++)
{
items.Add(new SelectListItem
{
Text = dtLocation.Rows[i]["Name"].ToString(),
Value = dtLocation.Rows[i]["OfficeId"].ToString()
});
}
}
else
{
items.Add(new SelectListItem
{
Text = "",
Value = ""
});
}
empAdmin.officeLocation = items;
items = new List <SelectListItem>();
if (dtEmploymentType != null && dtEmploymentType.Rows.Count > 0)
{
for (int i = 0; i < dtEmploymentType.Rows.Count; i++)
{
items.Add(new SelectListItem
{
Text = dtEmploymentType.Rows[i]["EmploymentType"].ToString(),
Value = dtEmploymentType.Rows[i]["EmptTypeId"].ToString()
});
}
}
else
{
items.Add(new SelectListItem
{
Text = "",
Value = ""
});
}
empAdmin.employmentType = items;
items = new List <SelectListItem>();
if (dtStatus != null && dtStatus.Rows.Count > 0)
{
for (int i = 0; i < dtStatus.Rows.Count; i++)
{
items.Add(new SelectListItem
{
Text = dtStatus.Rows[i]["EmpStatus"].ToString(),
Value = dtStatus.Rows[i]["EmpStatusId"].ToString()
});
}
}
else
{
items.Add(new SelectListItem
{
Text = "",
Value = ""
});
}
empAdmin.employmentStatus = items;
//Load Visa Type
//Load Salary Payment Type
items = new List <SelectListItem>();
items.Add(new SelectListItem()
{
Text = "Mr.", Value = "Mr."
});
items.Add(new SelectListItem()
{
Text = "Ms.", Value = "Ms."
});
items.Add(new SelectListItem()
{
Text = "Mrs.", Value = "Mrs."
});
empAdmin.title = items;
if (hdnId != null)//For New Joining
{
string JsonString = empService.SelectEmployeeInfo(Convert.ToInt32(hdnId), 48);
if (JsonString != string.Empty)
{
DataTable data = JsonConvert.DeserializeObject <DataTable>(JsonString);
empAdmin.firstName = Convert.ToString(data.Rows[0]["Name"]);
empAdmin.applicantId = Convert.ToInt32(hdnId);
}
}
return(View(empAdmin));
}
