public Emp_BasicInfoModel GetEmpManager(ClientContext clientContext, string Empcode) { Emp_BasicInfoModel EmpBal = new Emp_BasicInfoModel(); string filter = "EmpCode eq '" + Empcode + "'"; JArray jArray = RESTGet(clientContext, filter); EmpBal = new Emp_BasicInfoModel { ID = Convert.ToInt32(jArray[0]["ID"]), EmpCode = jArray[0]["EmpCode"] == null ? "" : Convert.ToString(jArray[0]["EmpCode"]), UserNameId = jArray[0]["User_Name"]["Id"] == null ? "" : Convert.ToString(jArray[0]["User_Name"]["Id"]), User_Name = jArray[0]["User_Name"]["Title"] == null ? "" : Convert.ToString(jArray[0]["User_Name"]["Title"]).Trim(), Manager = jArray[0]["Manager"]["FirstName"] == null ? "" : Convert.ToString(jArray[0]["Manager"]["FirstName"]), LastName = jArray[0]["Manager"]["LastName"] == null ? "" : Convert.ToString(jArray[0]["Manager"]["LastName"]), OfficeEmail = jArray[0]["Manager"]["OfficeEmail"] == null ? "" : Convert.ToString(jArray[0]["Manager"]["OfficeEmail"]), ManagerCode = jArray[0]["Manager"]["EmpCode"] == null ? "" : Convert.ToString(jArray[0]["Manager"]["EmpCode"]), Manager_Code = jArray[0]["Manager"]["ManagerCode"] == null ? "" : Convert.ToString(jArray[0]["Manager"]["ManagerCode"]), Department = jArray[0]["Department"]["DepartmentName"] == null ? "" : Convert.ToString(jArray[0]["Department"]["DepartmentName"]), ManagerId = jArray[0]["Manager"]["Id"] == null ? 0 : Convert.ToInt32(jArray[0]["Manager"]["Id"].ToString()) }; return(EmpBal); }
public ActionResult SaveInfo(Emp_BasicInfoModel EmpInfo) { int returnID = 0; // string ID = Request.Cookies["ID"].Value.ToString(); List <Emp_BasicInfoModel> empBasicinfo = (List <Emp_BasicInfoModel>)Session["managercode"]; // Emp_BasicInfoBal emp = new Emp_BasicInfoBal(); int a = '0'; if (empBasicinfo != null) { a = empBasicinfo.Count(); EmpInfo.EmpCode = "AW00" + a; var spContext = SharePointContextProvider.Current.GetSharePointContext(HttpContext); using (var clientContext = spContext.CreateUserClientContextForSPHost()) { foreach (Emp_BasicInfoModel emparr in empBasicinfo) { if (emparr.UserNameId == EmpInfo.Manager) { EmpInfo.Manager = (emparr.ID).ToString(); EmpInfo.ManagerCode = emparr.EmpCode; } } { string itemdata = "'FirstName' : '" + EmpInfo.FirstName + "',"; itemdata += "'MiddleName': '" + EmpInfo.MiddleName + "',"; itemdata += "'LastName': '" + EmpInfo.LastName + "',"; itemdata += "'EmpCode': '" + EmpInfo.EmpCode + "',"; itemdata += "'JoiningDate': '" + EmpInfo.JoiningDate + "',"; itemdata += "'DOB': '" + EmpInfo.DOB + "',"; itemdata += "'Gender': '" + EmpInfo.Gender + "',"; itemdata += "'MaritalStatus': '" + EmpInfo.MaritalStatus + "',"; itemdata += "'OnProbationTill': '" + EmpInfo.OnProbationTill + "',"; itemdata += "'ProbationStatus': '" + EmpInfo.ProbationStatus + "',"; itemdata += "'ManagerId': " + EmpInfo.Manager + ","; itemdata += "'ManagerCode': '" + EmpInfo.ManagerCode + "',"; itemdata += "'OfficeEmail': '" + EmpInfo.OfficeEmail + "',"; itemdata += "'ContactNumber': '" + EmpInfo.ContactNumber + "',"; itemdata += "'MobileNo': '" + EmpInfo.MobileNo + "',"; itemdata += "'CompanyId': '" + EmpInfo.Company + "',"; itemdata += "'DesignationId': '" + EmpInfo.Designation + "',"; itemdata += "'DepartmentId': '" + EmpInfo.Department + "',"; itemdata += "'DivisionId': '" + EmpInfo.Division + "',"; itemdata += "'RegionId': '" + EmpInfo.Region + "',"; itemdata += "'BranchId': '" + EmpInfo.Branch + "',"; itemdata += "'DOB_Months': '" + EmpInfo.DOB_Months + "',"; itemdata += "'JoiningDate_Month': '" + EmpInfo.JoiningDate_Month + "',"; itemdata += "'User_NameId': " + EmpInfo.User_Name + ""; emp.saveEmp(clientContext, itemdata); } } } return(Json(returnID, JsonRequestBehavior.AllowGet)); }
public ActionResult UpdateInfo(Emp_BasicInfoModel EditEmpInfo) { string returnID = "0"; string Id = EditEmpInfo.ID.ToString(); // string EmpId = Session["EMPID"].ToString(); // List<Emp_BasicInfoModel> empBasicinfo = (List<Emp_BasicInfoModel>)Session["manager"]; // string EditEmployeeID = Request.Cookies["EditEmployeeID"].Value; var spContext = SharePointContextProvider.Current.GetSharePointContext(HttpContext); using (var clientContext = spContext.CreateUserClientContextForSPHost()) { /* foreach (Emp_BasicInfoModel emparr in empBasicinfo) * { * if (emparr.UserNameId == EditEmpInfo.Manager) * { * EditEmpInfo.Manager = (emparr.ID).ToString(); * * EditEmpInfo.ManagerCode = emparr.EmpCode; * } * } */ // string itemdata = EditEmpInfo.FirstName == null ? "'FirstName' : null" : "'FirstName' : '" + EditEmpInfo.FirstName + "'"; // itemdata += EditEmpInfo.LastName == null ? ",'LastName' : null" : ",'LastName' : '" + EditEmpInfo.LastName + "'"; string itemdata = "'FirstName': '" + EditEmpInfo.FirstName + "',"; itemdata += "'CompanyId': " + EditEmpInfo.Company + ""; //items += emp_Publication.Publication == null ? ",'Publication':null" : ",'Publication':'" + emp_Publication.Publication + "'"; // itemdata += "'MiddleName': '" + EditEmpInfo.MiddleName + "',"; // itemdata += "'LastName': '" + EditEmpInfo.LastName + "'"; /* itemdata += "'JoiningDate': '" + EditEmpInfo.JoiningDate + "',"; * // itemdata += "'JoiningDate': '" + dt.ToString("MM/dd/yyyy") + "',"; * itemdata += "'DOB': '" + EditEmpInfo.DOB + "',"; * itemdata += "'Gender': '" + EditEmpInfo.Gender + "',"; * itemdata += "'MaritalStatus': '" + EditEmpInfo.MaritalStatus + "',"; * itemdata += "'OnProbationTill': '" + EditEmpInfo.OnProbationTill + "',"; * itemdata += "'ProbationStatus': '" + EditEmpInfo.ProbationStatus + "',"; * itemdata += "'ManagerId': " + EditEmpInfo.Manager + ","; * itemdata += "'ManagerCode': '" + EditEmpInfo.ManagerCode + "',"; * itemdata += "'OfficeEmail': '" + EditEmpInfo.OfficeEmail + "',"; * itemdata += "'ContactNumber': '" + EditEmpInfo.ContactNumber + "',"; * itemdata += "'MobileNo': '" + EditEmpInfo.MobileNo + "',"; * itemdata += "'CompanyId': " + EditEmpInfo.Company + ","; * itemdata += "'DesignationId': " + EditEmpInfo.Designation + ","; * itemdata += "'DepartmentId': " + EditEmpInfo.Department + ","; * itemdata += "'DivisionId': " + EditEmpInfo.Division + ","; * itemdata += "'RegionId': " + EditEmpInfo.Region + ","; * itemdata += "'BranchId':" + EditEmpInfo.Branch + ""; */ emp.UpdateEmp(clientContext, itemdata, Id); // VM_Emp_Detail.Empdata = emp.GetEmployeeById(clientContext, id); } return(Json(returnID, JsonRequestBehavior.AllowGet)); }
public ActionResult Index() { User spUser = null; var spContext = SharePointContextProvider.Current.GetSharePointContext(HttpContext); AuthenticateUser authenticateUser = new AuthenticateUser(); List <object> obj = new List <object>(); using (var clientContext = spContext.CreateUserClientContextForSPHost()) { if (clientContext != null) { string SPHostUrl = spContext.SPHostUrl.ToString(); // obj = authenticateUser.CheckUser(SPHostUrl); obj.Add("Authanticated"); if (obj.Count > 0) { if (obj[0].ToString() == "Authanticated") { Session["Authanticated"] = "Yes"; } else { Session["Authanticated"] = "No"; return(Redirect("/Error")); } } if (Session["Authanticated"].ToString() == "Yes") { spUser = clientContext.Web.CurrentUser; clientContext.Load(spUser, user => user.Id); clientContext.ExecuteQuery(); Session["UserID"] = spUser.Id; Session["Navigation"] = ""; ViewBag.UserName = spUser.Id; Emp_BasicInfoModel lstEmp = BalEmp.GetEmpMailByLogIn(clientContext); Session["UserName"] = lstEmp.FullName; Session["UserChar"] = lstEmp.FullName.Split(' ')[0].Substring(0, 1) + lstEmp.FullName.Split(' ')[1].Substring(0, 1); Session["UserMail"] = lstEmp.OfficeEmail; Session["UserPic"] = lstEmp.Profile_pic_url; Session["Hosturl"] = "http://" + spContext.SPHostUrl.Host; } } } return(View()); }
public ActionResult UpdateInfo(Emp_BasicInfoModel EditEmpInfo) { string returnID = "0"; string ID = EditEmpInfo.ID.ToString(); List <Emp_BasicInfoModel> empBasicinfo = (List <Emp_BasicInfoModel>)Session["managercode"]; var spContext = SharePointContextProvider.Current.GetSharePointContext(HttpContext); using (var clientContext = spContext.CreateUserClientContextForSPHost()) { foreach (Emp_BasicInfoModel emparr in empBasicinfo) { if (emparr.ID.ToString() == EditEmpInfo.Manager) { EditEmpInfo.Manager = (emparr.ID).ToString(); EditEmpInfo.ManagerCode = emparr.EmpCode; } } string itemdata = "'JoiningDate': '" + EditEmpInfo.JoiningDate + "',"; itemdata += "'DOB': '" + EditEmpInfo.DOB + "',"; itemdata += "'MaritalStatus': '" + EditEmpInfo.MaritalStatus + "',"; itemdata += "'Gender': '" + EditEmpInfo.Gender + "',"; //itemdata += "'MiddleName': '" + EditEmpInfo.MiddleName + "',"; //itemdata += "'LastName': '" + EditEmpInfo.LastName + "'"; itemdata += "'OnProbationTill': '" + EditEmpInfo.OnProbationTill + "',"; itemdata += "'ProbationStatus': '" + EditEmpInfo.ProbationStatus + "',"; itemdata += "'ManagerId': " + EditEmpInfo.Manager + ","; itemdata += "'ManagerCode': '" + EditEmpInfo.ManagerCode + "',"; itemdata += "'OfficeEmail': '" + EditEmpInfo.OfficeEmail + "',"; itemdata += "'ContactNumber': '" + EditEmpInfo.ContactNumber + "',"; itemdata += "'MobileNo': '" + EditEmpInfo.MobileNo + "',"; itemdata += "'DOB_Months': '" + EditEmpInfo.DOB_Months + "',"; itemdata += "'JoiningDate_Month': '" + EditEmpInfo.JoiningDate_Month + "',"; itemdata += "'CompanyId': " + EditEmpInfo.Company + ","; itemdata += "'DesignationId': " + EditEmpInfo.Designation + ","; itemdata += "'DepartmentId': " + EditEmpInfo.Department + ","; itemdata += "'DivisionId': " + EditEmpInfo.Division + ","; itemdata += "'RegionId': " + EditEmpInfo.Region + ","; itemdata += "'BranchId':" + EditEmpInfo.Branch + ""; emp.UpdateEmp(clientContext, itemdata, ID); } return(Json(returnID, JsonRequestBehavior.AllowGet)); }
public JsonResult AddTimesheet(System.Web.Mvc.FormCollection formCollection) { List <object> obj = new List <object>(); List <TIM_DocumentLibraryModel> DeleteDocument = new List <TIM_DocumentLibraryModel>(); List <TIM_EmployeeTimesheetModel> DeleteEmpTimesheet = new List <TIM_EmployeeTimesheetModel>(); var Timesheet = formCollection["TimesheetDetails"]; List <TIM_EmployeeTimesheetModel> EmpTimesheet = JsonConvert.DeserializeObject <List <TIM_EmployeeTimesheetModel> >(Timesheet); var DeleteTimesheet = formCollection["DeleteTimesheet"]; if (DeleteTimesheet != null) { DeleteEmpTimesheet = JsonConvert.DeserializeObject <List <TIM_EmployeeTimesheetModel> >(DeleteTimesheet); } var deletedoc = formCollection["DeleteDocument"]; if (deletedoc != null) { DeleteDocument = JsonConvert.DeserializeObject <List <TIM_DocumentLibraryModel> >(deletedoc); } int i = 0; string InternalStatus = "Inprogress"; var spContext = SharePointContextProvider.Current.GetSharePointContext(HttpContext); try { using (var clientContext = spContext.CreateUserClientContextForSPHost()) { List <TIM_StatusMasterModel> lstPendingStatus = new List <TIM_StatusMasterModel>(); lstPendingStatus = BalStatus.GetPendingStatus(clientContext); List <GEN_ApproverRoleNameModel> lstApprover = BalApprover.getApproverData(clientContext, BalEmp.GetEmpCodeByLogIn(clientContext), "Timesheet", "Main"); Emp_BasicInfoModel Employee = BalEmp.GetEmpMailByLogIn(clientContext); if (DeleteDocument.Count > 0) { int z = 0; foreach (var deleteItem in DeleteDocument) { string Result = BalDocument.DeleteDocument(clientContext, deleteItem.ID.ToString()); if (Result == "Delete") { z++; } } if (z != DeleteDocument.Count) { obj.Add("ERROR"); return(Json(obj, JsonRequestBehavior.AllowGet)); } } if (DeleteEmpTimesheet.Count > 0) { int z = 0; List <TIM_WorkFlowMasterModel> lstTimesheetDeletion = new List <TIM_WorkFlowMasterModel>(); lstTimesheetDeletion = BalWorkflow.GetTimesheetDeletion(clientContext); var DeleteItem = "'StatusId': '" + lstTimesheetDeletion[0].ToStatusID + "'"; DeleteItem += " ,'InternalStatus': '" + lstTimesheetDeletion[0].InternalStatus + "'"; foreach (var deleteEmpItem in DeleteEmpTimesheet) { string Result = BalEmpTimesheet.UpdateTimesheet(clientContext, DeleteItem, deleteEmpItem.ID.ToString()); if (Result == "Update") { var hours = deleteEmpItem.Hours.Split(':'); var h = Convert.ToInt32(hours[0]) * (-1); var m = Convert.ToInt32(hours[1]) * (-1); var NewHours = h.ToString() + ":" + m.ToString(); deleteEmpItem.AlterUtilizeHour = NewHours; string status = GetAndEditPrevTimesheet(clientContext, deleteEmpItem); if (status != "OK") { obj.Add("ERROR"); return(Json(obj, JsonRequestBehavior.AllowGet)); } else { z++; } } } if (z != DeleteEmpTimesheet.Count) { obj.Add("ERROR"); return(Json(obj, JsonRequestBehavior.AllowGet)); } } int ParentID = 0; List <TIM_TimesheetParentModel> PrevParentTimesheet = new List <TIM_TimesheetParentModel>(); PrevParentTimesheet = BalParentTimesheet.GetEmpTimesheetByTimesheetId(clientContext, EmpTimesheet[0].TimesheetID); if (PrevParentTimesheet.Count == 0) { string ParentItemData = " 'EmployeeId': '" + Employee.ID + "'"; ParentItemData += " ,'TimesheetID': '" + EmpTimesheet[0].TimesheetID + "'"; ParentItemData += " ,'StatusId': '" + lstPendingStatus[0].ID + "'"; ParentItemData += " ,'InternalStatus': '" + InternalStatus + "'"; ParentItemData += " ,'ManagerId': '" + lstApprover[0].ID + "'"; ParentItemData += " ,'TimesheetAddedDate': '" + EmpTimesheet[0].TimesheetAddedDate + "'"; ParentID = Convert.ToInt32(BalParentTimesheet.SaveTimesheet(clientContext, ParentItemData)); if (ParentID > 0) { var count = Convert.ToInt32(EmpTimesheet[0].TimesheetID.Split('-')[1]) + 1; string SettingItemData = " 'TimesheetCount': '" + count + "'"; string resID = BalSetting.UpdateSetting(clientContext, SettingItemData, "1"); if (resID != "Update") { obj.Add("ERROR"); return(Json(obj, JsonRequestBehavior.AllowGet)); } } } else { ParentID = PrevParentTimesheet[0].ID; } string returnID = "0"; foreach (var item in EmpTimesheet) { string itemdata = " 'Description': '" + item.Description.Replace("'", @"\'") + "'"; itemdata += " ,'Hours': '" + item.Hours + "'"; itemdata += " ,'EstimatedHours': '" + item.EstimatedHours + "'"; itemdata += " ,'UtilizedHours': '" + item.UtilizedHours + "'"; itemdata += " ,'RemainingHours': '" + item.RemainingHours + "'"; itemdata += " ,'TimesheetAddedDate': '" + item.TimesheetAddedDate + "'"; itemdata += " ,'EmployeeId': '" + Employee.ID + "'"; itemdata += " ,'ManagerId': '" + lstApprover[0].ID + "'"; itemdata += " ,'FromTime': '" + item.FromTime + "'"; itemdata += " ,'ToTime': '" + item.ToTime + "'"; itemdata += " ,'AllTaskStatusId': '" + item.AllTaskStatus + "'"; itemdata += " ,'TimesheetID': '" + item.TimesheetID + "'"; itemdata += " ,'StatusId': '" + lstPendingStatus[0].ID + "'"; itemdata += " ,'InternalStatus': '" + InternalStatus + "'"; itemdata += " ,'ParentIDId': '" + ParentID + "'"; itemdata += " ,'OtherClient': '" + item.OtherClient + "'"; itemdata += " ,'OtherProject': '" + item.OtherProject + "'"; itemdata += " ,'OtherMilestone': '" + item.OtherMilestone + "'"; itemdata += " ,'OtherTask': '" + item.OtherTask + "'"; if (item.ID > 0) { if (item.AlterUtilizeHour != null && item.AlterUtilizeHour != "") { string status = GetAndEditPrevTimesheet(clientContext, item); if (status != "OK") { obj.Add("ERROR"); return(Json(obj, JsonRequestBehavior.AllowGet)); } } returnID = BalEmpTimesheet.UpdateTimesheet(clientContext, itemdata, item.ID.ToString()); if (returnID == "Update") { if (Request.Files.Count > 0) { UploadTimesheetDoc(clientContext, Request.Files, item, item.ID.ToString()); } i++; } } else { itemdata += " ,'ProjectId': '" + item.Project + "'"; itemdata += " ,'TaskId': '" + item.Task + "'"; itemdata += " ,'SubTaskId': '" + item.SubTask + "'"; itemdata += " ,'ClientId': '" + item.Client + "'"; itemdata += " ,'MileStoneId': '" + item.MileStone + "'"; returnID = BalEmpTimesheet.SaveTimesheet(clientContext, itemdata); if (Convert.ToInt32(returnID) > 0) { item.ParentID = ParentID; string status = EditPrevTimesheetForNew(clientContext, item); if (status != "OK") { obj.Add("ERROR"); return(Json(obj, JsonRequestBehavior.AllowGet)); } else { if (Request.Files.Count > 0) { UploadTimesheetDoc(clientContext, Request.Files, item, returnID); } string Mailres = EmailCtrl.TimesheetCreationNotification(clientContext, EmpTimesheet[0], lstApprover[0], Employee); if (Convert.ToInt32(Mailres) > 0) { i++; } } } } } if (i == EmpTimesheet.Count) { obj.Add("OK"); } } } catch (Exception ex) { obj.Add("ERROR"); return(Json(obj, JsonRequestBehavior.AllowGet)); throw new Exception(string.Format("An error occured while performing action. GUID: {0}", ex.ToString())); } return(Json(obj, JsonRequestBehavior.AllowGet)); }
public string SubTaskAssignmentNotification(ClientContext clientContext, TIM_SubTaskModel item, Emp_BasicInfoModel AssignedBy) { string returnID = ""; try { string Fromdate = DateTime.ParseExact(item.StartDate, "MM-dd-yyyy hh:mm:ss", CultureInfo.InvariantCulture).ToString("dd-MM-yyyy", CultureInfo.InvariantCulture); string Todate = DateTime.ParseExact(item.EndDate, "MM-dd-yyyy hh:mm:ss", CultureInfo.InvariantCulture).ToString("dd-MM-yyyy", CultureInfo.InvariantCulture); string Subject = "Sub Task Assignment Notification"; string MainBody = "<table style='width: 100%; border: 1px solid black'><tbody><tr><th>Project</th><td>:</td><td>" + item.ProjectName + "</td></tr><tr><th>Milestone</th><td>:</td><td>" + item.MileStoneName + "</td></tr><tr><th>Task</th><td>:</td><td>" + item.TaskName + "</td></tr><tr><th>Subtask</th><td>:</td><td>" + item.SubTask + "</td></tr><tr><th>Member</th><td>:</td><td>" + item.MembersName + "</td></tr><tr><th>Start Date</th><td>:</td><td>" + Fromdate + "</td></tr><tr><th>End Date</th><td>:</td><td>" + Todate + "</td></tr></tbody></table>"; string Body = "Dear Member,<br /><br />The following new subtask has been assigned to you by " + AssignedBy.FullName + ".<br /><br />"; string ItemData = "'To': '" + item.MembersEmail + "'"; ItemData += " ,'Subject': '" + Subject + "'"; ItemData += " ,'Body': '" + Body + getDescriptionFormatted(MainBody) + "'"; returnID = BalEmail.SaveMail(clientContext, ItemData); if (Convert.ToInt32(returnID) > 0) { string NewBody = "<div>Dear Member,<br /><br />You have assigned the following new subtask to " + item.MembersName + ".<br /><br />"; string ItemDataNew = "'To': '" + AssignedBy.OfficeEmail + "'"; ItemDataNew += " ,'Subject': '" + Subject + "'"; ItemDataNew += " ,'Body': '" + NewBody + getDescriptionFormatted(MainBody) + "'"; returnID = BalEmail.SaveMail(clientContext, ItemDataNew); } } catch { } return(returnID); }
public string TimesheetCreationNotification(ClientContext clientContext, TIM_EmployeeTimesheetModel item, GEN_ApproverRoleNameModel Manager, Emp_BasicInfoModel Employee) { string returnID = ""; try { string AddedDate = DateTime.ParseExact(item.TimesheetAddedDate, "MM-dd-yyyy hh:mm:ss", CultureInfo.InvariantCulture).ToString("dd-MM-yyyy", CultureInfo.InvariantCulture); string InternalStatus = "Inprogress"; string Subject = "Timesheet Creation Notification"; string MainBody = "<table style='width: 100%; border: 1px solid black'><tbody><tr><th>Timesheet ID</th><td>:</td><td>" + item.TimesheetID + "</td></tr><tr><th>Date</th><td>:</td><td>" + AddedDate + "</td></tr><tr><th>Manager</th><td>:</td><td>" + Manager.FullName + "</td></tr><tr><th>Employee</th><td>:</td><td>" + Employee.FullName + "</td></tr><tr><th>Status</th><td>:</td><td>" + InternalStatus + "</td></tr></tbody></table>"; string Body = "Dear Member,<br /><br />The following new timesheet has been created by you.<br /><br />"; string ItemData = "'To': '" + Employee.OfficeEmail + "'"; ItemData += " ,'Subject': '" + Subject + "'"; ItemData += " ,'Body': '" + Body + getDescriptionFormatted(MainBody) + "'"; returnID = BalEmail.SaveMail(clientContext, ItemData); if (Convert.ToInt32(returnID) > 0) { string NewBody = "<div>Dear Member,<br /><br />The following timesheet has been created by " + Employee.FullName + " and awaiting for your approval. <br /><br />"; string ItemDataNew = "'To': '" + Manager.Email + "'"; ItemDataNew += " ,'Subject': '" + Subject + "'"; ItemDataNew += " ,'Body': '" + NewBody + getDescriptionFormatted(MainBody) + "'"; returnID = BalEmail.SaveMail(clientContext, ItemDataNew); } } catch { } return(returnID); }
public List <GEN_ApproverRoleNameModel> getApproverData(ClientContext clientContext, string empcode, string module, string approvertype) { // approver details model List <GEN_ApproverRoleNameModel> approverRoleNameModel = new List <GEN_ApproverRoleNameModel>(); // create object for gen_approver master GEN_ApproverMasterModel approverMasterModel = new GEN_ApproverMasterModel(); string filter = "Module eq '" + module + "' and Approver_Type eq '" + approvertype + "'"; JArray jArray = RestGetApproverLevels(clientContext, filter); //List<GEN_ApproverRoleListModel> approverRoleListModels = new List<GEN_ApproverRoleListModel>(); //GEN_ApproverRoleListBal approverRoleListBal = new GEN_ApproverRoleListBal(); //approverRoleListModels = approverRoleListBal.GetApproverRoleListBals(clientContext); Emp_BasicInfoBal basicInfoBal = new Emp_BasicInfoBal(); approverMasterModel = new GEN_ApproverMasterModel { ID = Convert.ToInt32(jArray[0]["ID"]), Module = jArray[0]["Module"] == null ? "" : Convert.ToString(jArray[0]["Module"]), Approver_Type = jArray[0]["Approver_Type"] == null ? "" : Convert.ToString(jArray[0]["Approver_Type"]), Rule_For_Filter_Type = jArray[0]["Rule_For_Filter_Type"] == null ? "" : Convert.ToString(jArray[0]["Rule_For_Filter_Type"]), Rule_For_Filter_Data = jArray[0]["Rule_For_Filter_Data"] == null ? "" : Convert.ToString(jArray[0]["Rule_For_Filter_Data"]), ApproverRoleName = jArray[0]["ApproverRoleName"] == null ? "" : Convert.ToString(jArray[0]["ApproverRoleName"]), ApproverRoleInternalName = jArray[0]["ApproverRoleInternalName"] == null ? "" : Convert.ToString(jArray[0]["ApproverRoleInternalName"]) }; List <string> rolenamearr = new List <string>(); rolenamearr = approverMasterModel.ApproverRoleInternalName.Split(',').ToList(); // call Emp-basicinfimodel class Emp_BasicInfoBal emp_BasicInfo = new Emp_BasicInfoBal(); Emp_BasicInfoModel basicInfoManager = new Emp_BasicInfoModel(); basicInfoManager = emp_BasicInfo.GetEmpManager(clientContext, empcode); for (int i = 0; i < rolenamearr.Count; i++) { if (rolenamearr[i] == "Manager") { if (basicInfoManager.ManagerCode != null) { approverRoleNameModel.Add(new GEN_ApproverRoleNameModel { Sequence = i, Role = rolenamearr[i], Empcode = basicInfoManager.ManagerCode, Email = basicInfoManager.OfficeEmail, FullName = basicInfoManager.Manager + " " + basicInfoManager.LastName, ID = basicInfoManager.ManagerId, }); } } else if (rolenamearr[i] == "ManagersManager") { if (basicInfoManager.Manager_Code != null) { approverRoleNameModel.Add(new GEN_ApproverRoleNameModel { Sequence = i, Role = rolenamearr[i], Empcode = basicInfoManager.Manager_Code }); } } else if (rolenamearr[i] == "DepartmentHead") { if (basicInfoManager.Department != null) { Emp_DepartmentModel departmentModel = new Emp_DepartmentModel(); Emp_DepartmentBal departmentBal = new Emp_DepartmentBal(); departmentModel = departmentBal.GetDepartmentHead(clientContext, basicInfoManager.Department); approverRoleNameModel.Add(new GEN_ApproverRoleNameModel { Sequence = i, Role = rolenamearr[i], Empcode = departmentModel.HeadOfDepartment }); } } else if (rolenamearr[i] == "AssetAllocateDepartment") { GEN_ApproverRoleListModel _ApproverRoleListModel = new GEN_ApproverRoleListModel(); GEN_ApproverRoleListBal _ApproverRoleListBal = new GEN_ApproverRoleListBal(); _ApproverRoleListModel = _ApproverRoleListBal.GetEmpByRole(clientContext, rolenamearr[i]); approverRoleNameModel.Add(new GEN_ApproverRoleNameModel { Sequence = i, Role = rolenamearr[i], Empcode = _ApproverRoleListModel.Empcode }); } } return(approverRoleNameModel); }