public ActionResult BHBulkSetupForm(int?ActionState)
{
SuperBulkSetupModel superBulkSetupModel;
if (ActionState != null && ActionState == 0)
{
BHSingleSetupModel bhs = new BHSingleSetupModel {
BranchName = SelectListItemHelper.GetBranches(),
AppraisalPeriod = SelectListItemHelper.GetAppraisalPeriod(String.Empty)
};
BHBulkSetupFormModel bhb = new BHBulkSetupFormModel();
List <SetupExcelModel> sem = new List <SetupExcelModel>();
superBulkSetupModel = new SuperBulkSetupModel();
superBulkSetupModel.BHBulkSetupFormModel = bhb;
superBulkSetupModel.SetupExcelModel = sem;
superBulkSetupModel.BHSingleSetupModel = bhs;
return(View(superBulkSetupModel));
}
string periodSelectedValue = (TempData["periodSelectedValue"] != null) ? TempData["periodSelectedValue"].ToString() : String.Empty;
BHSingleSetupModel bHSingleSetupModel = new BHSingleSetupModel {
BranchName = SelectListItemHelper.GetBranches(),
AppraisalPeriod = SelectListItemHelper.GetAppraisalPeriod(periodSelectedValue)
};
if (TempData["superBulkSetupModel"] != null)
{
superBulkSetupModel = TempData["superBulkSetupModel"] as SuperBulkSetupModel;
}
else
{
if (ViewBag.HasGrid != null)
{
superBulkSetupModel = TempData["superBulkSetupModel"] as SuperBulkSetupModel;
}
else
{
BHBulkSetupFormModel bHBulkSetupFormModel = new BHBulkSetupFormModel();
List <SetupExcelModel> setupExcelModel = new List <SetupExcelModel>();
superBulkSetupModel = new SuperBulkSetupModel();
superBulkSetupModel.BHBulkSetupFormModel = bHBulkSetupFormModel;
superBulkSetupModel.SetupExcelModel = setupExcelModel;
String ErrorMessage = TempData["ErrorMessage"] as String;
if (ErrorMessage != null)
{
ViewBag.ErrorMessage = ErrorMessage;
}
}
}
superBulkSetupModel.BHSingleSetupModel = bHSingleSetupModel;
return(View(superBulkSetupModel));
}
public ActionResult BHBulkSetupForm(SuperBulkSetupModel superBulkSetupModel, int?i)
{
HRProfile hrprofile = new LINQCalls().hrprofile(superBulkSetupModel.BHSingleSetupModel.InitiatorLoginName, 1);
if (hrprofile == null)
{
TempData["ErrorMessage"] = "Error : You staff profile is not properly setup";
TempData["superBulkSetupModel"] = superBulkSetupModel;
return(RedirectToAction("BHBulkSetupForm"));
}
//now get the initiator model and convert it to a datatable
List <SetupExcelModel> setupExcelModel = GetDataTableFromSpreadsheet(superBulkSetupModel.BHBulkSetupFormModel.UploadedExcelFile.InputStream, false, superBulkSetupModel.BHSingleSetupModel, hrprofile);
if (setupExcelModel.Count() <= 0)
{
TempData["ErrorMessage"] = "Error : Please upload an excel file before continuing";
TempData["superBulkSetupModel"] = superBulkSetupModel;
return(RedirectToAction("BHBulkSetupForm"));
}
var staffinputmodel = setupExcelModel.Select(entry => new StaffInputModel()
{
BranchCode = entry.StaffBranchCode
, BranchName = entry.StaffBranch
, InitiatorName = entry.StaffName
, InitiatorNumber = entry.StaffNumber
//, InitiatorGrade = String.Empty
, Comments = String.Empty
, AppraisalPeriod = entry.SelectedAppraisalPeriod
, HODeptCode = "" //entry.HODeptCode
, HODeptName = "" //entry.HODeptName
, HRStaffNumber = entry.HRProfile.employee_number
, HRStaffName = entry.HRProfile.name
}).ToList();
IEnumerable <StaffInputModel> staffInputModel = staffinputmodel;
DataTable dataTable = ToDataTable(staffInputModel);
//now upload the list to the db
string retVal = new AppDatabase().insertBulkSetup(dataTable, "AppraisalDbConnectionString");
if (retVal != null)
{
TempData["UploadComplete"] = "false";
TempData["ErrorMessage"] = retVal;
TempData["superBulkSetupModel"] = superBulkSetupModel;
return(RedirectToAction("BHBulkSetupForm"));
}
TempData["UploadComplete"] = "true";
return(RedirectToAction("BHBulkSetupForm", new { ActionState = 0 }));
}
public ActionResult BHBulkSetupForm(SuperBulkSetupModel superBulkSetupModel)
{
HRProfile hrprofile = new LINQCalls().hrprofile(superBulkSetupModel.BHSingleSetupModel.InitiatorLoginName, 1);
if (hrprofile == null)
{
TempData["ErrorMessage"] = "Error : You staff profile is not properly setup";
TempData["superBulkSetupModel"] = superBulkSetupModel;
return(RedirectToAction("BHBulkSetupForm"));
}
string periodSelectedValue = Request.Form["BHSingleSetupModel.SelectedAppraisalPeriod"];
HttpPostedFileBase uploadedExcelFile = superBulkSetupModel.BHBulkSetupFormModel.UploadedExcelFile;
superBulkSetupModel.BHSingleSetupModel.Comments = "";
BHBulkSetupFormModel bHBulkSetupFormModel = superBulkSetupModel.BHBulkSetupFormModel;
List <SetupExcelModel> setupExcelModel = GetDataTableFromSpreadsheet(bHBulkSetupFormModel.UploadedExcelFile.InputStream, false, superBulkSetupModel.BHSingleSetupModel, hrprofile);
superBulkSetupModel.SetupExcelModel = setupExcelModel;
TempData["periodSelectedValue"] = periodSelectedValue;
TempData["superBulkSetupModel"] = superBulkSetupModel;
return(RedirectToAction("BHBulkSetupForm"));
}
