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