public IActionResult ASOICatDetailNew(string rp_id)
{
pageSetUp();
ASOIModel model = new ASOIModel();
model.Detail = new ASOIResultModel();
model.Sch = new ASOISearchModel();
model.List_id = rp_id;
model.Detail = ASOIService.GetModelDetail(model.Detail, rp_id);
int count_rp = ASOIService.CountDetailASOI(rp_id);
if (count_rp != 0)
{
model.Detail.Detail_list = ASOIService.GetDetailList(rp_id);
}
//model.Detail.Detail_list.AddRange(new SubList[10]);
model.Detail.Detail_list.Add(new SubList());
model.Detail.Detail_list.Add(new SubList());
model.Detail.Detail_list.Add(new SubList());
model.Detail.Detail_list.Add(new SubList());
model.Detail.Detail_list.Add(new SubList());
model.Detail.Detail_list.Add(new SubList());
model.Detail.Detail_list.Add(new SubList());
model.Detail.Detail_list.Add(new SubList());
model.Detail.Detail_list.Add(new SubList());
model.Detail.Detail_list.Add(new SubList());
model.Detail.CountRp = count_rp;
return(View(model));
}
public IActionResult ASOICatDetailUpdate(ASOIModel model)
{
var login_id = UserHelper.UserInfo(((ClaimsIdentity)User.Identity), "LoginId");
if (model.Update_type == "new")
{
for (int i = model.Detail.CountRp; i < model.Detail.CountRp + 10; i++)
{
if (!string.IsNullOrEmpty(model.Detail.Detail_list[i].Prog_desc) || !string.IsNullOrEmpty(model.Detail.Detail_list[i].Prog_organizer) ||
!string.IsNullOrEmpty(model.Detail.Detail_list[i].Start_date) || !string.IsNullOrEmpty(model.Detail.Detail_list[i].End_date) ||
model.Detail.Detail_list[i].Income != 0 || model.Detail.Detail_list[i].Pe != 0 ||
model.Detail.Detail_list[i].Oc != 0 || !string.IsNullOrEmpty(model.Detail.Detail_list[i].Remarks))
{
string st_dt = model.Detail.Detail_list[i].Start_date;
if (!(string.IsNullOrEmpty(st_dt)))
{
model.Detail.Detail_list[i].Start_date = DateTime.ParseExact(st_dt, "dd/MM/yyyy", CultureInfo.InvariantCulture).ToString("yyyy-MM-dd");
}
string end_dt = model.Detail.Detail_list[i].End_date;
if (!(string.IsNullOrEmpty(end_dt)))
{
model.Detail.Detail_list[i].End_date = DateTime.ParseExact(end_dt, "dd/MM/yyyy", CultureInfo.InvariantCulture).ToString("yyyy-MM-dd");
}
model.Detail.Detail_list[i].Prog_desc = string.IsNullOrEmpty(model.Detail.Detail_list[i].Prog_desc) ? "": model.Detail.Detail_list[i].Prog_desc.Replace("'", "''");
model.Detail.Detail_list[i].Prog_organizer = string.IsNullOrEmpty(model.Detail.Detail_list[i].Prog_organizer) ? "" : model.Detail.Detail_list[i].Prog_organizer.Replace("'", "''");
model.Detail.Detail_list[i].Remarks = string.IsNullOrEmpty(model.Detail.Detail_list[i].Remarks) ? "" : model.Detail.Detail_list[i].Remarks.Replace("'", "''");
model.Detail.Detail_list[i].Rp_id = model.List_id;
ASOIService.InsertAsDetailASOI(model.Detail.Detail_list[i], login_id);
}
}
}
else if (model.Update_type == "edit")
{
for (int i = 0; i < model.Detail.CountRp; i++)
{
if (model.Detail.Detail_list[i].Id != "")
{
string st_dt = model.Detail.Detail_list[i].Start_date;
if (st_dt != "")
{
model.Detail.Detail_list[i].Start_date = DateTime.ParseExact(st_dt, "dd/MM/yyyy", CultureInfo.InvariantCulture).ToString("yyyy-MM-dd");
}
string end_dt = model.Detail.Detail_list[i].End_date;
if (end_dt != "")
{
model.Detail.Detail_list[i].End_date = DateTime.ParseExact(end_dt, "dd/MM/yyyy", CultureInfo.InvariantCulture).ToString("yyyy-MM-dd");
}
model.Detail.Detail_list[i].Prog_desc = string.IsNullOrEmpty(model.Detail.Detail_list[i].Prog_desc) ? "" : model.Detail.Detail_list[i].Prog_desc.Replace("'", "''");
model.Detail.Detail_list[i].Prog_organizer = string.IsNullOrEmpty(model.Detail.Detail_list[i].Prog_organizer) ? "" : model.Detail.Detail_list[i].Prog_organizer.Replace("'", "''");
model.Detail.Detail_list[i].Remarks = string.IsNullOrEmpty(model.Detail.Detail_list[i].Remarks) ? "" : model.Detail.Detail_list[i].Remarks.Replace("'", "''");
ASOIService.UpdateAsDetailASOI(model.Detail.Detail_list[i], login_id);
}
}
}
return(RedirectToAction("ASOICatDetail", new { rp_id = model.List_id }));
}
public IActionResult ASOICatEdit(string hosp_code, string list_id, string sch_cat_no, string sch_analytical_start = "", string sch_analytical_end = "",
string sch_section = "", string sch_description_location = "", string sch_nature_income = "", string sch_organizer_department = "", string sch_start_date_begin = "",
string sch_start_date_until = "", string sch_service_provided = "", string sch_program_code = "", string sch_prog_subcat = "", string sch_allcat = "",
string analytical_edit = "", string section_edit = "", string Duplicate = "")
{
pageSetUp();
ASOIModel model = new ASOIModel();
model.Sch = new ASOISearchModel();
model.Detail = new ASOIResultModel();
model.Sch.Hosp_code = hosp_code;
model.Detail.Hosp_code = hosp_code;
model.List_id = list_id;
model.Analytical_edit = analytical_edit;
model.Section_edit = section_edit;
model.Duplicate = Duplicate;
model.Sch.Sch_cat_no = sch_cat_no;
model.Sch.Sch_allcat = sch_allcat;
model.Sch.Sch_analytical_start = sch_analytical_start;
model.Sch.Sch_analytical_end = sch_analytical_end;
model.Sch.Sch_section = sch_section;
if (!string.IsNullOrEmpty(sch_description_location))
{
model.Sch.Sch_description_location = sch_description_location.Replace("\"\"", """);
}
model.Sch.Sch_nature_income = sch_nature_income;
if (!string.IsNullOrEmpty(sch_organizer_department))
{
model.Sch.Sch_organizer_department = sch_organizer_department.Replace("\"\"", """);
}
model.Sch.Sch_service_provided = sch_service_provided;
model.Sch.Sch_start_date_begin = sch_start_date_begin;
model.Sch.Sch_start_date_until = sch_start_date_until;
model.Sch.Sch_program_code = sch_program_code;
model.Sch.Sch_prog_subcat = sch_prog_subcat;
model.Sch.Cat_no = ASOIService.GetCatNoById(list_id);
model.Detail.Cat = model.Sch.Cat_no;
model.Sch.Cat_name = ASOIService.GetCatName(model.Sch.Cat_no);
model.Detail.Cat_name = model.Sch.Cat_name;
model.Sch.Period = ASOIService.GetPeriod();
model.Detail.Period = model.Sch.Period;
model.Detail = ASOIService.GetASOIResult(model);
ViewBag.SubCatByCatNo = ASOIService.GetSubCatByCatNo(model.Detail.Cat, "(" + Resource.PleaseSelect + ")");
ViewBag.NatureIncomeByCatNo = ASOIService.GetNatureIncomeByCatNo(model.Detail.Cat, "(" + Resource.PleaseSelect + ")");
ViewBag.ServiceProvidedByCatNo = ASOIService.GetServiceProvidedByCatNo(model.Detail.Cat, "(" + Resource.PleaseSelect + ")");
ViewBag.PeriodNote = ASOIService.GetPeriodFromERPGL();
return(View(model));
}
public IActionResult ASOICatDetailEdit(string rp_id)
{
pageSetUp();
ASOIModel model = new ASOIModel();
model.Detail = new ASOIResultModel();
model.Sch = new ASOISearchModel();
model.List_id = rp_id;
model.Detail = ASOIService.GetModelDetail(model.Detail, rp_id);
int count_rp = ASOIService.CountDetailASOI(rp_id);
model.Detail.CountRp = count_rp;
model.Detail.Detail_list = ASOIService.GetDetailList(rp_id);
return(View(model));
}
public ASOIResultModel GetASOIResult(ASOIModel model)
{
var ds = AsASOIProgrammesRepository.GetASOIResultById(model.List_id);
if (ds != null && ds.Tables.Count != 0 && ds.Tables[0].Rows.Count != 0)
{
model.Detail.Analytical = ds.Tables[0].Rows[0]["analytical"].ToString();
model.Detail.Section = ds.Tables[0].Rows[0]["section"].ToString();
model.Detail.Program_code = ds.Tables[0].Rows[0]["program_code"].ToString();
model.Detail.No_project = ds.Tables[0].Rows[0]["no_project"].ToString();
model.Detail.Prog_sub_cat = ds.Tables[0].Rows[0]["prog_sub_cat"].ToString();
model.Detail.Prog_desc = ds.Tables[0].Rows[0]["prog_desc"].ToString().Replace("\"\"", """);
model.Detail.Start_date = DateTime.Parse(ds.Tables[0].Rows[0]["start_date"].ToString()).ToString("dd/MM/yyyy");
model.Detail.End_date = DateTime.Parse(ds.Tables[0].Rows[0]["end_date"].ToString()).ToString("dd/MM/yyyy");
model.Detail.Prog_organizer = ds.Tables[0].Rows[0]["prog_organizer"].ToString().Replace("\"\"", """);
model.Detail.Service_provided = ds.Tables[0].Rows[0]["service_provided"].ToString();
model.Detail.Contract_signed = ds.Tables[0].Rows[0]["contract_signed"].ToString();
model.Detail.Nature_income = ds.Tables[0].Rows[0]["nature_income"].ToString();
model.Detail.Roll_over = ds.Tables[0].Rows[0]["roll_over"].ToString();
model.Detail.Ytd_income = Convert.ToDecimal(ds.Tables[0].Rows[0]["ytd_income"].ToString());
model.Detail.Ytd_pe = Convert.ToDecimal(ds.Tables[0].Rows[0]["ytd_pe"].ToString());
model.Detail.Ytd_oc = Convert.ToDecimal(ds.Tables[0].Rows[0]["ytd_oc"].ToString());
model.Detail.Cyp_income = Convert.ToDecimal(ds.Tables[0].Rows[0]["cyp_income"].ToString());
model.Detail.Cyp_pe = Convert.ToDecimal(ds.Tables[0].Rows[0]["cyp_pe"].ToString());
model.Detail.Cyp_oc = Convert.ToDecimal(ds.Tables[0].Rows[0]["cyp_oc"].ToString());
model.Detail.Poa_income = Convert.ToDecimal(ds.Tables[0].Rows[0]["poa_income"].ToString());
model.Detail.Poa_pe = Convert.ToDecimal(ds.Tables[0].Rows[0]["poa_pe"].ToString());
model.Detail.Poa_oc = Convert.ToDecimal(ds.Tables[0].Rows[0]["poa_oc"].ToString());
model.Detail.Remarks = ds.Tables[0].Rows[0]["remarks"].ToString().Replace("\"\"", """);
model.Detail.Ytd_sd = model.Detail.Ytd_income + model.Detail.Ytd_pe + model.Detail.Ytd_oc;
model.Detail.Cyp_sd = model.Detail.Cyp_income + model.Detail.Cyp_pe + model.Detail.Cyp_oc;
model.Detail.Poa_sd = model.Detail.Poa_income + model.Detail.Poa_pe + model.Detail.Poa_oc;
model.Detail.Remarks = ds.Tables[0].Rows[0]["remarks"].ToString();
if (model.Detail.Start_date.ToString() == "01/01/1900")
{
model.Detail.Start_date = "";
}
if (model.Detail.End_date.ToString() == "01/01/1900")
{
model.Detail.End_date = "";
}
}
return(model.Detail);
}
public IActionResult ASOICatNew(string cat_no, string hosp_code, string analytical = "", string section = "", string program_code = "",
string no_project = "", string prog_sub_cat = "", string prog_desc = "", string prog_organizer = "", string service_provided = "",
string contract_signed = "", string nature_income = "", string roll_over = "", string cyp_income = "", string cyp_pe = "",
string cyp_oc = "", string poa_income = "", string poa_pe = "", string poa_oc = "", string remarks = "", string start_date = "",
string end_date = "", string Duplicate = "")
{
pageSetUp();
ViewBag.SubCatByCatNo = ASOIService.GetSubCatByCatNo(cat_no, "(" + Resource.PleaseSelect + ")");
ViewBag.NatureIncomeByCatNo = ASOIService.GetNatureIncomeByCatNo(cat_no, "(" + Resource.PleaseSelect + ")");
ViewBag.ServiceProvidedByCatNo = ASOIService.GetServiceProvidedByCatNo(cat_no, "(" + Resource.PleaseSelect + ")");
ASOIModel model = new ASOIModel();
model.Detail = new ASOIResultModel();
model.Detail.Cat = cat_no;
model.Detail.Hosp_code = hosp_code;
model.Detail.Cat_name = ASOIService.GetCatName(cat_no);
model.Detail.Period = ASOIService.GetPeriod();
model.Detail.Analytical = analytical;
model.Detail.Section = section;
model.Detail.Program_code = program_code;
model.Detail.No_project = no_project;
model.Detail.Prog_sub_cat = prog_sub_cat;
model.Detail.Prog_desc = prog_desc;
model.Detail.Prog_organizer = prog_organizer;
model.Detail.Service_provided = service_provided;
model.Detail.Contract_signed = contract_signed;
model.Detail.Nature_income = nature_income;
model.Detail.Roll_over = roll_over;
model.Detail.Cyp_income = Convert.ToDecimal(cyp_income);
model.Detail.Cyp_pe = Convert.ToDecimal(cyp_pe);
model.Detail.Cyp_oc = Convert.ToDecimal(cyp_oc);
model.Detail.Poa_income = Convert.ToDecimal(poa_income);
model.Detail.Poa_pe = Convert.ToDecimal(poa_pe);
model.Detail.Poa_oc = Convert.ToDecimal(poa_oc);
model.Detail.Remarks = remarks;
model.Detail.Start_date = start_date;
model.Detail.End_date = end_date;
model.Duplicate = Duplicate;
return(View(model));
}
public IActionResult ASOICatDetail(string rp_id)
{
pageSetUp();
ASOIModel model = new ASOIModel();
model.Detail = new ASOIResultModel();
model.Sch = new ASOISearchModel();
model.List_id = rp_id;
int count_rp = ASOIService.CountDetailASOI(rp_id);
if (count_rp == 0 && ViewBag.PrivilegeAsoiInput == "I")
{
return(RedirectToAction("ASOICatDetailNew", new { rp_id = rp_id }));
}
else
{
model.Detail = ASOIService.GetModelDetail(model.Detail, rp_id);
if (count_rp != 0)
{
model.Detail.Detail_list = ASOIService.GetDetailList(rp_id);
}
}
return(View(model));
}
public IActionResult ASOICatUpdate(ASOIModel model)
{
var login_id = UserHelper.UserInfo(((ClaimsIdentity)User.Identity), "LoginId");
int duplicate_cnt = 0;
if (model.Update_type == "new")
{
//check whether the record is duplicated
if (model.Detail.Analytical != "ZZZZZ" && model.Detail.Section != "ZZZZZZZ")
{
model.Detail.Period = ASOIService.GetPeriodShortMth();
int duplicate = ASOIService.CheckIfRecordExist(model.Detail.Analytical, model.Detail.Section, model.Detail.Hosp_code, model.Detail.Period);
duplicate_cnt = duplicate;
if (duplicate > 0)
{
return(RedirectToAction("ASOICatNew", new
{
cat_no = model.Detail.Cat,
hosp_code = model.Detail.Hosp_code,
analytical = model.Detail.Analytical,
section = model.Detail.Section,
program_code = model.Detail.Program_code,
no_project = model.Detail.No_project,
prog_sub_cat = model.Detail.Prog_sub_cat,
prog_desc = model.Detail.Prog_desc,
prog_organizer = model.Detail.Prog_organizer,
service_provided = model.Detail.Service_provided,
contract_signed = model.Detail.Contract_signed,
nature_income = model.Detail.Nature_income,
roll_over = model.Detail.Roll_over,
cyp_income = model.Detail.Cyp_income,
cyp_pe = model.Detail.Cyp_pe,
cyp_oc = model.Detail.Cyp_oc,
poa_income = model.Detail.Poa_income,
poa_pe = model.Detail.Poa_pe,
poa_oc = model.Detail.Poa_oc,
remarks = model.Detail.Remarks,
start_date = model.Detail.Start_date,
end_date = model.Detail.End_date,
Duplicate = "true"
}));
}
}
var new_id = ASOIService.GenNewRecordId();
ASOIService.InsertAsASOIProgrammesRecord(new_id, model.Detail, login_id);
}
else if (model.Update_type == "edit")
{
//check whether the record is duplicated
if (model.Detail.Analytical != "ZZZZZ" && model.Detail.Section != "ZZZZZZZ")
{
model.Detail.Period = ASOIService.GetPeriodShortMth();
int duplicateRecord_Edit = ASOIService.CheckIfRecordExist(model.Detail.Analytical, model.Detail.Section, model.Detail.Hosp_code, model.Detail.Period, model.List_id);
duplicate_cnt = duplicateRecord_Edit;
if (duplicateRecord_Edit > 0)
{
return(RedirectToAction("ASOICatEdit", new
{
hosp_code = model.Detail.Hosp_code,
list_id = model.List_id,
sch_cat_no = model.Detail.Cat,
analytical_edit = model.Detail.Analytical,
section_edit = model.Detail.Section,
Duplicate = "true"
}));
}
}
ASOIService.UpdateAsASOIProgrammesRecord(model.List_id, model.Detail, login_id);
}
else if (model.Update_type == "delete")
{
ASOIService.DeleteAsASOIProgrammesRecordById(model.List_id);
}
if (model.Update_type == "new" || model.Update_type == "edit")
{
model.Detail.Period = ASOIService.GetPeriodShortMth();
ASOIService.AsUpdateFromAsGL(model.Detail.Period, model.Detail.Hosp_code, model.Detail.Analytical, model.Detail.Section);
}
if (model.Update_type == "edit" && model.Submit_type == "UpdateYTD")
{
return(RedirectToAction("ASOICatEdit", new
{
hosp_code = model.Detail.Hosp_code,
list_id = model.List_id,
sch_cat_no = model.Detail.Cat
}));
}
else if (model.Update_type == "edit" && model.Submit_type == "SaveNComplete")
{
return(RedirectToAction("Index", new
{
cat_no = model.Detail.Cat,
hosp_code = model.Detail.Hosp_code,
//list_id = model.List_id,
search_corp = "search"
}));
}
else if (model.Update_type == "new" && duplicate_cnt == 0)
{
return(RedirectToAction("ASOICatEdit", new
{
hosp_code = model.Detail.Hosp_code,
list_id = model.List_id,
sch_cat_no = model.Detail.Cat
}));
}
else if (model.Update_type == "delete")
{
return(RedirectToAction("Index", new
{
cat_no = model.Detail.Cat,
hosp_code = model.Detail.Hosp_code,
}));
}
return(RedirectToAction("Index", new { cat_no = model.Detail.Cat, hosp_code = model.Detail.Hosp_code }));
}
