public object GetAttendanceDistrinctDelegateDetailsByRotarianName(GetAttendanceRotarian_Input Input)
{
dynamic TBGetRotarianResult;
try
{
List <GetAttendanceDelegateDetailsByRotarianName> Result = Attendance.GetAttendanceDistrinctDelegateDetailsByRotarianName(Input);
if (Result != null)
{
TBGetRotarianResult = new { status = "0", message = "success", Result };
}
else
{
TBGetRotarianResult = new { status = "0", message = "Record not found" };
}
}
catch
{
TBGetRotarianResult = new { status = "1", message = "failed" };
}
return(new { TBGetRotarianResult });
}
public static List <GetAttendanceDelegateDetailsByRotarianName> GetAttendanceDistrinctDelegateDetailsByRotarianName(GetAttendanceRotarian_Input Input)
{
try
{
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("?p_RotarianName", Input.RotarianName);
using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
{
context.Connection.Open();
var Result = context.ExecuteStoreQuery <GetAttendanceDelegateDetailsByRotarianName>("CALL USP_API_Mobile_GetAttendanceDistrinctByRotarianName(?p_RotarianName)", param).ToList();
return(Result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <GetAttendanceDelegateDetailsByRotarianName> GetAttendanceDistrinctDelegateDetailsByRotarianName(GetAttendanceRotarian_Input Input)
{
try
{
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("?p_RotarianName", Input.RotarianName);
var Result = _DbTouchbase.ExecuteStoreQuery <GetAttendanceDelegateDetailsByRotarianName>("CALL USP_API_Mobile_GetAttendanceDistrinctByRotarianName(?p_RotarianName)", param).ToList();
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <GetAttendanceRotarianDetailsbyID> GetrotarianDetailsbyRotarianID(GetAttendanceRotarian_Input Input)
{
try
{
MySqlParameter[] param = new MySqlParameter[1];
param[0] = new MySqlParameter("?p_RotarianID", Input.RotarianID);
var Result = _DbTouchbase.ExecuteStoreQuery <GetAttendanceRotarianDetailsbyID>("CALL USP_API_Mobile_GetrotarianDetailsbyRotarianID(?p_RotarianID)", param).ToList();
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
