public object GetAttendanceListNew(GetAttendanceListNew_Input Input)
{
dynamic TBAttendanceListResult;
List <object> AttendanceListResult = new List <object>();
try
{
List <GetAttendanceListNew> Result = Attendance.getAttendanceListNew(Input);
for (int i = 0; i < Result.Count; i++)
{
AttendanceListResult.Add(new { AttendanceResult = Result[i] });
}
if (AttendanceListResult != null)
{
TBAttendanceListResult = new { status = "0", message = "success", AttendanceListResult };
}
else
{
TBAttendanceListResult = new { status = "0", message = "Record not found" };
}
}
catch
{
TBAttendanceListResult = new { status = "1", message = "failed" };
}
return(new { TBAttendanceListResult });
}
//Created By Mukesh A. Dhole
public static List <GetAttendanceListNew> getAttendanceListNew(GetAttendanceListNew_Input Input)
{
try
{
MySqlParameter[] param = new MySqlParameter[2];
param[0] = new MySqlParameter("?p_groupProfileID", Input.groupProfileID);
param[1] = new MySqlParameter("?p_groupID", Input.groupID);
var Result = _DbTouchbase.ExecuteStoreQuery <GetAttendanceListNew>("CALL USP_API_Mobile_getAttendanceListNew(?p_groupProfileID,?p_groupID)", param).ToList();
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
//Created By Mukesh A. Dhole
public static List <GetAttendanceEventsListNew> getAttendanceEventsListNew(GetAttendanceListNew_Input Input)
{
try
{
MySqlParameter[] param = new MySqlParameter[3];
param[0] = new MySqlParameter("?grpId", Input.groupID);
param[1] = new MySqlParameter("?searchText", Input.searchText);
param[2] = new MySqlParameter("?filterType", Input.type);
var Result = _DbTouchbase.ExecuteStoreQuery <GetAttendanceEventsListNew>("CALL WEBAttendanceGetEventList(?grpId,?searchText,?filterType)", param).ToList();
return(Result);
}
catch (Exception ex)
{
throw ex;
}
}
//Created By Mukesh A. Dhole
public static List <GetAttendanceEventsListNew> getAttendanceEventsListNew(GetAttendanceListNew_Input Input)
{
try
{
MySqlParameter[] param = new MySqlParameter[3];
param[0] = new MySqlParameter("?grpId", Input.groupID);
param[1] = new MySqlParameter("?searchText", Input.searchText);
param[2] = new MySqlParameter("?filterType", Input.type);
using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
{
context.Connection.Open();
var Result = context.ExecuteStoreQuery <GetAttendanceEventsListNew>("CALL WEBAttendanceGetEventList(?grpId,?searchText,?filterType)", param).ToList();
return(Result);
}
}
catch (Exception ex)
{
throw ex;
}
}
//Created By Mukesh A. Dhole
public static List <GetAttendanceListNew> getAttendanceListNew(GetAttendanceListNew_Input Input)
{
try
{
MySqlParameter[] param = new MySqlParameter[2];
param[0] = new MySqlParameter("?p_groupProfileID", Input.groupProfileID);
param[1] = new MySqlParameter("?p_groupID", Input.groupID);
using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
{
context.Connection.Open();
var Result = context.ExecuteStoreQuery <GetAttendanceListNew>("CALL USP_API_Mobile_getAttendanceListNew(?p_groupProfileID,?p_groupID)", param).ToList();
return(Result);
}
}
catch (Exception ex)
{
throw ex;
}
}
