public static ArrayList LoadRepeatRegistrationData(Repeat_Registration_Data data)
{
ArrayList arr = new ArrayList();
string query;
try
{
query = "EXEC [dbo].[Autocomplete_Repeat_Registration_Data] '" + data.Semester_Id + "',2";
DataTable result = DBConnection.selectRecords(query);
foreach (DataRow dtRow in result.Rows)
{
Repeat_Registration_Data rtn = new Repeat_Registration_Data();
rtn.Semester_Id = dtRow["Semester_Id"].ToString();
rtn.Repeat_Registration_Start_Date = dtRow["Repeat_Registration_Start_Date"].ToString();
rtn.Repeat_Registration_End_Date = dtRow["Repeat_Registration_End_Date"].ToString();
rtn.Repeat_Fee = dtRow["Repeat_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 SaveRepeatRegistrationData(Repeat_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 <Repeat_Registration_Subject_List> MDetails = new List <Repeat_Registration_Subject_List>();
MDetails = data.Repeat_Registration_Subject_List.ToList <Repeat_Registration_Subject_List>();
foreach (Repeat_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_Repeat_Registration_Data] '"
+ UUID + "','"
+ data.Semester_Id + "','"
+ data.Repeat_Registration_Start_Date + "','"
+ data.Repeat_Registration_End_Date + "','"
+ data.Repeat_Fee + "','"
+ data.Status + "'";
DBConnection.PerformBulkCopy(MappingTable, "[dbo].Temp_Repeat_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 SaveRepeatRegistrationData(Repeat_Registration_Data data)
{
return(Ok(DA_AdminController.SaveRepeatRegistrationData(data)));
}
