public ActionResult ExportExcelAssignings()
{
BaseAssigningsBLL AssigningBLL = AssigingsFactory.CreateAssigning(AssigningsTypesEnum.Internal);
var data = Json(new
{
data = AssigningBLL.GetAssignings().Select(x => new
{
x.AssigningID,
EmployeeCodeNo = x.EmployeeCareerHistory.EmployeeCode.EmployeeCodeNo,
EmployeeNameAr = x.EmployeeCareerHistory.EmployeeCode.Employee.EmployeeNameAr,
AssigningStartDate = Globals.Calendar.GetUmAlQuraDate(x.AssigningStartDate),
AssigningEndDate = x.AssigningEndDate.HasValue ? Globals.Calendar.GetUmAlQuraDate(x.AssigningEndDate.Value) : "",
OrganizationName = x.AssigningType.AssigningTypeID == (int)AssigningsTypesEnum.Internal ? ((InternalAssigningBLL)x).Organization.FullOrganizationName : ((ExternalAssigningBLL)x).ExternalOrganization,
JobName = x.AssigningType.AssigningTypeID == (int)AssigningsTypesEnum.Internal ? ((InternalAssigningBLL)x).Job.JobName : string.Empty,
IsFinished = x.IsFinished,
})
}, JsonRequestBehavior.AllowGet);
Dictionary <string, string> ColumnNames = new Dictionary <string, string>
{
{ "AssigningID", Resources.Globalization.SequenceNoText },
{ "EmployeeCodeNo", Resources.Globalization.EmployeeCodeNoText },
{ "EmployeeNameAr", Resources.Globalization.EmployeeNameArText },
{ "AssigningStartDate", Resources.Globalization.AssigningStartDateText },
{ "AssigningEndDate", Resources.Globalization.AssigningEndDateText },
{ "IsFinished", Resources.Globalization.AssigningIsFinishedText },
{ "OrganizationName", Resources.Globalization.OrganizationNameText },
{ "JobName", Resources.Globalization.JobNameText }
};
string fileName = ExcelHelper.ExportToExcel(Json(data), ColumnNames);
return(Json(new { DownLoadFile = fileName }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetAssigningID()
{
BaseAssigningsBLL AssigningBLL = AssigingsFactory.CreateAssigning(AssigningsTypesEnum.Internal);
AssigningBLL.AssigningID = int.Parse(Session["AssigningID"].ToString());
return(Json(new { data = AssigningBLL }, JsonRequestBehavior.AllowGet));
}
public HttpResponseMessage AssignEmployeeUnderOrganizationManager(int EmployeeCodeID, int OrganizationID, int JobID)
{
InternalAssigningBLL assigning = (InternalAssigningBLL)AssigingsFactory.CreateAssigning(AssigningsTypesEnum.Internal);
assigning.EmployeeCareerHistory = new EmployeesCareersHistoryBLL().GetEmployeeCurrentJob(EmployeeCodeID);
assigning.Manager = new EmployeesCodesBLL()
{
EmployeeCodeID = this.WindowsEmployeeCode.EmployeeCodeID
};
assigning.Organization = new OrganizationsStructuresBLL()
{
OrganizationID = OrganizationID
};
assigning.Job = new JobsBLL()
{
JobID = JobID
};
assigning.LoginIdentity = new EmployeesCodesBLL()
{
EmployeeCodeID = this.WindowsEmployeeCode.EmployeeCodeID
};
if (assigning.EmployeeCareerHistory.EmployeeCareerHistoryID == 0)
{
throw new CustomException(Resources.Globalization.NoCareerHistoryExistsToEmployeeText);
}
Result result = assigning.AssignEmployeeUnderManager();
if (result.EnumMember == OrganizationStructureValidationEnum.RejectedBecauseOfPlacementPeriodFinished.ToString())
{
throw new CustomException(Resources.Globalization.EmployeesPlacementPeriodFinishedText);
}
else if (result.EnumMember == AssigningsValidationEnum.RejectedBecauseOfActivePreviousAssigning.ToString())
{
InternalAssigningBLL assgining = (InternalAssigningBLL)result.Entity;
throw new CustomException(Resources.Globalization.ValidationEmployeeAlreadyAssignedToOrgText
+ " NewLine" + Resources.Globalization.ManagerNameArText + " : " + (assgining.Manager != null ? assgining.Manager.Employee.EmployeeNameAr : string.Empty)
+ " NewLine" + Resources.Globalization.OrganizationNameText + " : " + assgining.Organization.GetOrganizationNameTillLastParentExceptPresident(assgining.Organization.OrganizationID)
);
}
else
{
return(new HttpResponseMessage(HttpStatusCode.OK));
}
}
public ActionResult GetAssigningsWillExpire()
{
BaseAssigningsBLL AssigningBLL = AssigingsFactory.CreateAssigning(AssigningsTypesEnum.Internal);
return(Json(new
{
data = AssigningBLL.GetAssigningsWillExpire(DateTime.Now, 1).Select(x => new
{
x.AssigningID,
EmployeeCodeNo = x.EmployeeCareerHistory.EmployeeCode.EmployeeCodeNo,
EmployeeNameAr = x.EmployeeCareerHistory.EmployeeCode.Employee.EmployeeNameAr,
AssigningStartDate = x.AssigningStartDate,
AssigningEndDate = x.AssigningEndDate,
IsFinished = x.IsFinished,
})
}, JsonRequestBehavior.AllowGet));
}
public HttpResponseMessage RemoveEmployeeFromOrganizationManager(int AssigningID)
{
InternalAssigningBLL assigningBLL = (InternalAssigningBLL)AssigingsFactory.CreateAssigning(AssigningsTypesEnum.Internal);
assigningBLL.AssigningID = AssigningID;
assigningBLL.LoginIdentity = new EmployeesCodesBLL()
{
EmployeeCodeID = this.WindowsEmployeeCode.EmployeeCodeID
};
Result result = assigningBLL.RemoveEmployeeFromManager();
if (result.EnumMember == OrganizationStructureValidationEnum.RejectedBecauseOfPlacementPeriodFinished.ToString())
{
throw new CustomException(Resources.Globalization.EmployeesPlacementPeriodFinishedText);
}
else
{
return(new HttpResponseMessage(HttpStatusCode.OK));
}
}
public string GetOrganizationName(int EmployeeCareerHistoryID)
{
string OrgName = "";
BaseAssigningsBLL AssigningBLL = AssigingsFactory.CreateAssigning(AssigningsTypesEnum.Internal);
AssigningBLL = AssigningBLL.GetEmployeeActiveAssigning(EmployeeCareerHistoryID);
if (AssigningBLL != null && AssigningBLL.AssigningID > 0)
{
if (AssigningBLL.AssigningType.AssigningTypeID == (int)AssigningsTypesEnum.Internal)
{
OrgName = ((InternalAssigningBLL)AssigningBLL).Organization.FullOrganizationName;
}
else
{
OrgName = ((ExternalAssigningBLL)AssigningBLL).ExternalOrganization;
}
}
return(OrgName);
}
public ActionResult GetAssignings()
{
BaseAssigningsBLL AssigningBLL = AssigingsFactory.CreateAssigning(AssigningsTypesEnum.Internal);
AssigningBLL.Search = Search;
AssigningBLL.Order = Order;
AssigningBLL.OrderDir = OrderDir;
AssigningBLL.StartRec = StartRec;
AssigningBLL.PageSize = PageSize;
var data = AssigningBLL.GetAssignings(out TotalRecordsOut, out RecFilterOut).Select(x => new
{
x.AssigningID,
EmployeeCodeNo = x.EmployeeCareerHistory.EmployeeCode.EmployeeCodeNo,
EmployeeNameAr = x.EmployeeCareerHistory.EmployeeCode.Employee.EmployeeNameAr,
AssigningStartDate = x.AssigningStartDate,
AssigningEndDate = x.AssigningEndDate,
IsFinished = x.IsFinished,
});
return(Json(new { draw = Convert.ToInt32(Draw), recordsTotal = TotalRecordsOut, recordsFiltered = RecFilterOut, data = data }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetEmployeesUnderManagerByOrganization(int OrganizationID)
{
BaseAssigningsBLL AssigningBLL = AssigingsFactory.CreateAssigning(AssigningsTypesEnum.Internal);
List <InternalAssigningBLL> Employees = new InternalAssigningBLL()
{
Organization = new OrganizationsStructuresBLL()
{
OrganizationID = OrganizationID
},
Manager = new EmployeesCodesBLL()
{
EmployeeCodeID = this.WindowsEmployeeCode.EmployeeCodeID
}
}.GetEmployeesUnderManagerByOrganization();
if (Employees != null)
{
return(Json(new
{
data = Employees.Select(x => new
{
AssigningID = x.AssigningID,
EmployeeCodeID = x.EmployeeCareerHistory?.EmployeeCode?.EmployeeCodeID,
EmployeeCodeNo = x.EmployeeCareerHistory?.EmployeeCode?.EmployeeCodeNo,
EmployeeIDNo = x.EmployeeCareerHistory?.EmployeeCode?.Employee?.EmployeeIDNo,
FullEmployeeName = x.EmployeeCareerHistory?.EmployeeCode?.Employee?.EmployeeNameAr,
OrganizationName = x.EmployeeCareerHistory != null ? x.Organization?.OrganizationName : string.Empty,
JobName = x.EmployeeCareerHistory != null ? x.Job?.JobName : string.Empty,
AssigningReason = x.AssigningReason?.AssigningReasonName,
CreatedDate = x.CreatedDate
})
}, JsonRequestBehavior.AllowGet));
}
else
{
throw new Exception();
}
}
public HttpResponseMessage EndingEmployeeAssigning(AssigningsViewModel AssigningVM)
{
BaseAssigningsBLL assigning = (InternalAssigningBLL)AssigingsFactory.CreateAssigning(AssigningsTypesEnum.Internal);
assigning.AssigningID = AssigningVM.AssigningID;
assigning.LoginIdentity = WindowsEmployeeCode;
//assigning.EmployeeCareerHistory = new EmployeesCareersHistoryBLL() { EmployeeCode = new EmployeesCodesBLL() { emplo } }
//assigning.AssigningEndDate = DateTime.Now;
//assigning.AssigningEndReason = new AssigningsReasonsBLL() { AssigningReasonID = AssigningVM.EndAssigningReasonID };
//assigning.Notes = AssigningVM.Notes;
Result result = assigning.BreakLastAssigning(AssigningVM.EmployeeCodeID, DateTime.Now, (AssigningsReasonsEnum)AssigningVM.EndAssigningReasonID, assigning.Notes);
if (result.EnumMember == OrganizationStructureValidationEnum.RejectedBecauseOfPlacementPeriodFinished.ToString())
{
throw new CustomException(Resources.Globalization.EmployeesPlacementPeriodFinishedText);
}
else
{
return(new HttpResponseMessage(HttpStatusCode.OK));
}
}
public ActionResult EditAssigning(AssigningsViewModel AssigningVM)
{
if (AssigningVM.AssigningType.AssigningTypeID == (Int32)AssigningsTypesEnum.Internal)
{
InternalAssigningBLL assigning = (InternalAssigningBLL)AssigingsFactory.CreateAssigning(AssigningsTypesEnum.Internal);
assigning.AssigningID = AssigningVM.AssigningID;
assigning.AssigningType = new AssigningsTypesBLL()
{
AssigningTypeID = (Int32)AssigningsTypesEnum.Internal
};
assigning.AssigningStartDate = AssigningVM.AssginingStartDate.Value.Date;
//assigning.AssigningEndDate = AssigningVM.AssginingEndDate.HasValue ? AssigningVM.AssginingEndDate.Value.Date : (DateTime?)null;
//assigning.IsFinished = AssigningVM.IsFinished;
assigning.EmployeeCareerHistory = new EmployeesCareersHistoryBLL()
{
EmployeeCareerHistoryID = AssigningVM.EmployeeCareerHistoryID
};
assigning.Job = new JobsBLL()
{
JobID = AssigningVM.JobID.HasValue ? AssigningVM.JobID.Value : 0
};
assigning.Organization = new OrganizationsStructuresBLL()
{
OrganizationID = AssigningVM.OrganizationID.Value
};
assigning.Manager = AssigningVM.ManagerCodeID.HasValue ? new EmployeesCodesBLL()
{
EmployeeCodeID = AssigningVM.ManagerCodeID.Value
} : null;
assigning.AssigningReason = new AssigningsReasonsBLL()
{
AssigningReasonID = AssigningVM.AssigningReason.AssigningReasonID
};
assigning.LoginIdentity = new EmployeesCodesBLL()
{
EmployeeCodeID = int.Parse(Session["EmployeeCodeID"].ToString())
};
assigning.AssigningReasonOther = AssigningVM.AssigningReasonOther;
Result result = assigning.Update();
if ((System.Type)result.EnumType == typeof(AssigningsValidationEnum))
{
if (result.EnumMember == AssigningsValidationEnum.Done.ToString())
{
BaseAssigningsBLL assgining = (BaseAssigningsBLL)result.Entity;
Session["AssigningID"] = ((InternalAssigningBLL)result.Entity).AssigningID;
}
else if (result.EnumMember == AssigningsValidationEnum.RejectedBecauseOfAlreadyFinished.ToString())
{
throw new CustomException(Resources.Globalization.ValidationBecauseOfAssigningAlreadyFinishedText);
}
//else if (result.EnumMember == AssigningsValidationEnum.RejectedBecauseOfActivePreviousAssigning.ToString())
//{
// BaseAssigningsBLL assgining = (BaseAssigningsBLL)result.Entity;
// throw new CustomException(Resources.Globalization.MustEndPreviousAssigningText + "NewLine" + "تاريخ اخر تكليف : " + assgining.AssigningStartDate.ToShortDateString());
//}
else if (result.EnumMember == AssigningsValidationEnum.RejectedBecauseOfConflictWithLenders.ToString())
{
LendersBLL Lender = ((LendersBLL)result.Entity);
throw new CustomException(string.Format(Resources.Globalization.ValidationConflictWithLenderText,
Lender.LenderStartDate.ToShortDateString(), Lender.LenderEndDate.ToShortDateString()));
}
else if (result.EnumMember == AssigningsValidationEnum.RejectedBecauseOfEndDateIsLessThanCreationDate.ToString())
{
throw new CustomException(Resources.Globalization.ValidationBecauseOfEndDateIsLessThanCreationDateText);
}
}
}
else if (AssigningVM.AssigningType.AssigningTypeID == (Int32)AssigningsTypesEnum.External)
{
ExternalAssigningBLL assigning = (ExternalAssigningBLL)AssigingsFactory.CreateAssigning(AssigningsTypesEnum.External);
assigning.AssigningID = AssigningVM.AssigningID;
assigning.AssigningType = new AssigningsTypesBLL()
{
AssigningTypeID = (Int32)AssigningsTypesEnum.External
};
assigning.AssigningStartDate = AssigningVM.AssginingStartDate.Value.Date;
//assigning.AssigningEndDate = AssigningVM.AssginingEndDate.HasValue ? AssigningVM.AssginingEndDate.Value.Date : (DateTime?)null;
//assigning.IsFinished = AssigningVM.IsFinished;
//assigning.Employee = new EmployeesCodesBLL() { EmployeeCodeID = AssigningVM.EmployeeCodeID };
assigning.EmployeeCareerHistory = new EmployeesCareersHistoryBLL()
{
EmployeeCareerHistoryID = AssigningVM.EmployeeCareerHistoryID
};
assigning.ExternalKSACity = new KSACitiesBLL()
{
KSACityID = AssigningVM.ExternalKSACity.KSACityID
};
assigning.ExternalOrganization = AssigningVM.ExternalOrganization;
assigning.AssigningReason = new AssigningsReasonsBLL()
{
AssigningReasonID = AssigningVM.AssigningReason.AssigningReasonID
};
assigning.LoginIdentity = new EmployeesCodesBLL()
{
EmployeeCodeID = int.Parse(Session["EmployeeCodeID"].ToString())
};
assigning.AssigningReasonOther = AssigningVM.AssigningReasonOther;
Result result = assigning.Update();
if ((System.Type)result.EnumType == typeof(AssigningsValidationEnum))
{
if (result.EnumMember == AssigningsValidationEnum.Done.ToString())
{
BaseAssigningsBLL assgining = (BaseAssigningsBLL)result.Entity;
Session["AssigningID"] = ((ExternalAssigningBLL)result.Entity).AssigningID;
}
else if (result.EnumMember == AssigningsValidationEnum.RejectedBecauseOfActivePreviousAssigning.ToString())
{
BaseAssigningsBLL assgining = (BaseAssigningsBLL)result.Entity;
throw new CustomException(Resources.Globalization.MustEndPreviousAssigningText + "NewLine" + Resources.Globalization.LastAssigningStartDateText + assgining.AssigningStartDate.ToShortDateString());
}
else if (result.EnumMember == AssigningsValidationEnum.RejectedBecauseOfConflictWithLenders.ToString())
{
LendersBLL Lender = ((LendersBLL)result.Entity);
throw new CustomException(string.Format(Resources.Globalization.ValidationConflictWithLenderText,
Lender.LenderStartDate.ToShortDateString(), Lender.LenderEndDate.ToShortDateString()));
}
else if (result.EnumMember == AssigningsValidationEnum.RejectedBecauseOfEndDateIsLessThanCreationDate.ToString())
{
throw new CustomException(Resources.Globalization.ValidationBecauseOfEndDateIsLessThanCreationDateText);
}
}
}
return(View(this.GetByAssigningID(AssigningVM.AssigningID)));
}
public ActionResult Create(AssigningsViewModel AssigningVM)
{
if (AssigningVM.AssigningType.AssigningTypeID == (Int32)AssigningsTypesEnum.Internal)
{
InternalAssigningBLL assigning = (InternalAssigningBLL)AssigingsFactory.CreateAssigning(AssigningsTypesEnum.Internal);
assigning.AssigningType = new AssigningsTypesBLL()
{
AssigningTypeID = (int)AssigningsTypesEnum.Internal
};
assigning.AssigningStartDate = AssigningVM.AssginingStartDate.Value.Date;
assigning.AssigningEndDate = AssigningVM.AssginingEndDate.HasValue ? AssigningVM.AssginingEndDate.Value.Date : (DateTime?)null;
assigning.EmployeeCareerHistory = new EmployeesCareersHistoryBLL().GetActiveByEmployeeCareerHistoryID(AssigningVM.EmployeeCareerHistoryID);
assigning.Manager = AssigningVM.ManagerCodeID.HasValue ? new EmployeesCodesBLL()
{
EmployeeCodeID = AssigningVM.ManagerCodeID.Value
} : null;
assigning.Job = new JobsBLL()
{
JobID = AssigningVM.JobID.HasValue ? AssigningVM.JobID.Value : 0
};
if (AssigningVM.OrganizationID.HasValue)
{
assigning.Organization = new OrganizationsStructuresBLL()
{
OrganizationID = AssigningVM.OrganizationID.Value
}
}
;
assigning.AssigningReason = new AssigningsReasonsBLL()
{
AssigningReasonID = AssigningVM.AssigningReason.AssigningReasonID
};
assigning.AssigningReasonOther = AssigningVM.AssigningReasonOther;
assigning.LoginIdentity = this.UserIdentity;
Result result = assigning.Add();
if ((System.Type)result.EnumType == typeof(NoConflictWithOtherProcessValidationEnum))
{
Classes.Helpers.CommonHelper.ConflictValidationMessage(result);
}
if ((System.Type)result.EnumType == typeof(AssigningsValidationEnum))
{
if (result.EnumMember == AssigningsValidationEnum.Done.ToString())
{
BaseAssigningsBLL assgining = (BaseAssigningsBLL)result.Entity;
Session["AssigningID"] = ((InternalAssigningBLL)result.Entity).AssigningID;
}
else if (result.EnumMember == AssigningsValidationEnum.RejectedBecauseOfActivePreviousAssigning.ToString())
{
BaseAssigningsBLL assgining = (BaseAssigningsBLL)result.Entity;
throw new CustomException(Resources.Globalization.MustEndPreviousAssigningText + "NewLine" + "تاريخ اخر تكليف : " + assgining.AssigningStartDate.ToShortDateString());
}
else if (result.EnumMember == AssigningsValidationEnum.RejectedBecauseOfConflictWithLenders.ToString())
{
LendersBLL Lender = ((LendersBLL)result.Entity);
throw new CustomException(string.Format(Resources.Globalization.ValidationConflictWithLenderText,
Lender.LenderStartDate.ToShortDateString(), Lender.LenderEndDate.ToShortDateString()));
}
else if (result.EnumMember == AssigningsValidationEnum.RejectedBecauseOfEndDateIsLessThanCreationDate.ToString())
{
throw new CustomException(Resources.Globalization.ValidationBecauseOfEndDateIsLessThanCreationDateText);
}
}
}
else if (AssigningVM.AssigningType.AssigningTypeID == (Int32)AssigningsTypesEnum.External)
{
ExternalAssigningBLL assigning = (ExternalAssigningBLL)AssigingsFactory.CreateAssigning(AssigningsTypesEnum.External);
assigning.AssigningType = new AssigningsTypesBLL()
{
AssigningTypeID = (int)AssigningsTypesEnum.External
};
assigning.AssigningStartDate = AssigningVM.AssginingStartDate.Value.Date;
assigning.AssigningEndDate = AssigningVM.AssginingEndDate.HasValue ? AssigningVM.AssginingEndDate.Value.Date : (DateTime?)null;
assigning.EmployeeCareerHistory = new EmployeesCareersHistoryBLL().GetActiveByEmployeeCareerHistoryID(AssigningVM.EmployeeCareerHistoryID);
assigning.ExternalKSACity = new KSACitiesBLL()
{
KSACityID = AssigningVM.ExternalKSACity.KSACityID
};
assigning.ExternalOrganization = AssigningVM.ExternalOrganization;
assigning.AssigningReason = new AssigningsReasonsBLL()
{
AssigningReasonID = AssigningVM.AssigningReason.AssigningReasonID
};
assigning.AssigningReasonOther = AssigningVM.AssigningReasonOther;
assigning.LoginIdentity = this.UserIdentity;
Result result = assigning.Add();
if ((System.Type)result.EnumType == typeof(NoConflictWithOtherProcessValidationEnum))
{
Classes.Helpers.CommonHelper.ConflictValidationMessage(result);
}
if ((System.Type)result.EnumType == typeof(AssigningsValidationEnum))
{
if (result.EnumMember == AssigningsValidationEnum.Done.ToString())
{
BaseAssigningsBLL assgining = (BaseAssigningsBLL)result.Entity;
Session["AssigningID"] = ((ExternalAssigningBLL)result.Entity).AssigningID;
}
else if (result.EnumMember == AssigningsValidationEnum.RejectedBecauseOfActivePreviousAssigning.ToString())
{
BaseAssigningsBLL assgining = (BaseAssigningsBLL)result.Entity;
throw new CustomException(Resources.Globalization.MustEndPreviousAssigningText + "NewLine" + "تاريخ اخر تكليف : " + assgining.AssigningStartDate.ToShortDateString());
}
else if (result.EnumMember == AssigningsValidationEnum.RejectedBecauseOfConflictWithLenders.ToString())
{
LendersBLL Lender = ((LendersBLL)result.Entity);
throw new CustomException(string.Format(Resources.Globalization.ValidationConflictWithLenderText,
Lender.LenderStartDate.ToShortDateString(), Lender.LenderEndDate.ToShortDateString()));
}
else if (result.EnumMember == AssigningsValidationEnum.RejectedBecauseOfEndDateIsLessThanCreationDate.ToString())
{
throw new CustomException(Resources.Globalization.ValidationBecauseOfEndDateIsLessThanCreationDateText);
}
}
}
return(View(AssigningVM));
}