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)));
}
