public object GetTouchbaseSetting(MainMasterId mem) { dynamic TBSettingResult; List <object> AllTBSettingResults = new List <object>(); try { List <SettingDetails> Result1 = Setting.getAllTouchbaseSetting(mem); for (int i = 0; i < Result1.Count; i++) { AllTBSettingResults.Add(new { SettingResult = Result1[i] }); } if (AllTBSettingResults != null) { TBSettingResult = new { status = "0", message = "success", AllTBSettingResults }; } else { TBSettingResult = new { status = "0", message = "Record not found" }; } } catch (System.Exception ex) { TBSettingResult = new { status = "1", message = "failed", ex.Message }; } return(new { TBSettingResult }); }
public static List <SettingDetails> getAllTouchbaseSetting(MainMasterId mem) { try { var mainMasterId = new MySqlParameter("?mainMasterId", mem.mainMasterId); var Result = _DbTouchbase.ExecuteStoreQuery <SettingDetails>("CALL USPGetTouchbase_rowSettings(?mainMasterId)", mainMasterId).ToList(); return(Result); } catch (Exception ex) { throw ex; } }
public static List <SettingDetails> getAllTouchbaseSetting(MainMasterId mem) { try { var mainMasterId = new MySqlParameter("?mainMasterId", mem.mainMasterId); using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities()) { context.Connection.Open(); var Result = context.ExecuteStoreQuery <SettingDetails>("CALL USPGetTouchbase_rowSettings(?mainMasterId)", mainMasterId).ToList(); return(Result); } } catch (Exception ex) { throw ex; } }