public void UpdateAsASOIProgrammesRecord(string list_id, ASOIResultModel model, string user_id)
{
AsASOIProgrammesRepository.UpdateAsASOIProgrammesRecord(list_id, model.Analytical, model.Section, model.Program_code,
model.No_project, model.Prog_sub_cat, model.Prog_desc, model.Prog_organizer, model.Service_provided, model.Start_date, model.End_date,
model.Contract_signed, model.Nature_income, model.Roll_over, model.Ytd_income.ToString(), model.Ytd_pe.ToString(), model.Ytd_oc.ToString(), model.Cyp_income.ToString(),
model.Cyp_pe.ToString(), model.Cyp_oc.ToString(), model.Poa_income.ToString(), model.Poa_pe.ToString(), model.Poa_oc.ToString(), model.Remarks, user_id);
}
public ASOIResultModel GetModelDetail(ASOIResultModel model, string rp_id)
{
var ds = AsASOIProgrammesRepository.GetASOIResultById(rp_id);
if (ds != null && ds.Tables.Count != 0 && ds.Tables[0].Rows.Count != 0)
{
model.Cat = ds.Tables[0].Rows[0]["cat"].ToString();
model.Hosp_code = ds.Tables[0].Rows[0]["hosp"].ToString();
model.Analytical = ds.Tables[0].Rows[0]["analytical"].ToString();
model.Section = ds.Tables[0].Rows[0]["section"].ToString();
}
model.Cat_name = AsCatInfoRepository.GetCatName(model.Cat);
model.Period = GetPeriod();
return(model);
}
public List <ASOIResultModel> GetASOIResultList(ASOISearchModel model)
{
List <ASOIResultModel> result = new List <ASOIResultModel>();
var ds = AsASOIProgrammesRepository.GetASOIResultList(model.Hosp_code, model.Get_max_period, model.Sch_allcat, model.Cat_no, model.Sch_start_date_begin,
model.Sch_start_date_until, model.Sch_analytical_start, model.Sch_analytical_end,
model.Sch_section, model.Sch_program_code, model.Sch_prog_subcat, model.Sch_description_location,
model.Sch_organizer_department, model.Sch_nature_income, model.Sch_service_provided);
if (ds != null && ds.Tables.Count != 0 && ds.Tables[0].Rows.Count != 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
ASOIResultModel asoi = new ASOIResultModel();
asoi.Id = dr["id"].ToString();
asoi.Cat = dr["cat"].ToString();
asoi.Analytical = dr["analytical"].ToString();
asoi.Section = dr["section"].ToString();
asoi.Program_code = dr["program_code"].ToString();
asoi.Prog_sub_cat = dr["prog_sub_cat"].ToString();
asoi.Prog_desc = dr["prog_desc"].ToString();
asoi.Nature_income = dr["nature_income"].ToString();
asoi.Prog_organizer = dr["prog_organizer"].ToString();
asoi.Service_provided = dr["service_provided"].ToString();
asoi.Start_date = DateTime.Parse(dr["start_date"].ToString()).ToString("dd/MM/yyyy");
asoi.No_project = model.Cat_no != "10" ? dr["no_project"].ToString() : "";
if (model.Sch_allcat == "all" || model.Subcat_check != "none")
{
asoi.Prog_sub_cat = AsProgSubcatRepository.GetSubCatByValue(dr["prog_sub_cat"].ToString());
}
asoi.Nature_income = AsNatureIncomeRepository.GetNatureIncomeById(dr["nature_income"].ToString());
asoi.Service_provided = AsServiceProvidedRepository.GetServiceProvidedById(dr["service_provided"].ToString());
if (asoi.Start_date.ToString() == "01/01/1900")
{
asoi.Start_date = "";
}
result.Add(asoi);
}
}
return(result);
}