public static ArrayList AutocompleteRepeatRegistrationData(Pro_Rata_Registration_Data data) { ArrayList arr = new ArrayList(); string query; try { query = "EXEC [dbo].[Autocomplete_Repeat_Registration_Data] '" + data.Semester_Id + "',1"; DataTable result = DBConnection.selectRecords(query); if (result != null) { foreach (DataRow dtRow in result.Rows) { Pro_Rata_Registration_Data rtn = new Pro_Rata_Registration_Data(); rtn.Semester_Id = dtRow["Semester_Id"].ToString(); arr.Add(rtn); } } return(arr); } catch (Exception ex) { throw ex; } }
public static ArrayList LoadProrataRegistrationData(Pro_Rata_Registration_Data data) { ArrayList arr = new ArrayList(); string query; try { query = "EXEC [dbo].[Autocomplete_Pro_Rata_Registration_Data] '" + data.Semester_Id + "',2"; DataTable result = DBConnection.selectRecords(query); foreach (DataRow dtRow in result.Rows) { Pro_Rata_Registration_Data rtn = new Pro_Rata_Registration_Data(); rtn.Semester_Id = dtRow["Semester_Id"].ToString(); rtn.Pro_Rata_Registration_Start_Date = dtRow["Pro_Rata_Registration_Start_Date"].ToString(); rtn.Pro_Rata_Registration_End_Date = dtRow["Pro_Rata_Registration_End_Date"].ToString(); rtn.Pro_Rata_Fee = dtRow["Pro_Rata_Fee"].ToString(); rtn.Last_Payment_Date_From = dtRow["Last_Payment_Date_From"].ToString(); rtn.Last_Payment_Date_To = dtRow["Last_Payment_Date_To"].ToString(); rtn.Late_Payment_Fee = dtRow["Late_Payment_Fee"].ToString(); rtn.Date_Time = dtRow["Allow_Subject_Name"].ToString(); // this is used to pass the subject list to the front end arr.Add(rtn); } return(arr); } catch (Exception ex) { throw ex; } }
public static String SaveProRataRegistrationData(Pro_Rata_Registration_Data data) { string str = ""; string query; string UUID = Guid.NewGuid().ToString(); ArrayList arr = new ArrayList(); try { DataTable MappingTable = new DataTable(); MappingTable.Columns.Add("Ref_No"); MappingTable.Columns.Add("Allow_Subject_Name"); List <Pro_Rata_Registration_Subject_List> MDetails = new List <Pro_Rata_Registration_Subject_List>(); MDetails = data.Pro_Rata_Registration_Subject_List.ToList <Pro_Rata_Registration_Subject_List>(); foreach (Pro_Rata_Registration_Subject_List item in MDetails) { DataRow itemRow = MappingTable.NewRow(); itemRow["Ref_No"] = UUID.ToString(); itemRow["Allow_Subject_Name"] = item.Allow_Subject_Name.ToString(); MappingTable.Rows.Add(itemRow); } query = "exec [dbo].[Save_Pro_Rata_Registration_Data] '" + UUID + "','" + data.Semester_Id + "','" + data.Pro_Rata_Registration_Start_Date + "','" + data.Pro_Rata_Registration_End_Date + "','" + data.Pro_Rata_Fee + "','" + data.Last_Payment_Date_From + "','" + data.Last_Payment_Date_To + "','" + data.Late_Payment_Fee + "','" + data.Status + "'"; DBConnection.PerformBulkCopy(MappingTable, "[dbo].Temp_Pro_Rata_Registration_Subject_List"); arr = DBConnection.selectRecord(query); if (arr.Count > 0) { str = "Success"; return(str); } else { str = "Error occur"; return(str); } } catch (Exception ex) { throw ex; } }
public IHttpActionResult AutocompleteRepeatRegistrationData(Pro_Rata_Registration_Data data) { return(Ok(DA_AdminController.AutocompleteRepeatRegistrationData(data))); }
public IHttpActionResult LoadProrataRegistrationData(Pro_Rata_Registration_Data data) { return(Ok(DA_AdminController.LoadProrataRegistrationData(data))); }