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