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