// Eto yung function dun sa cloud bio private JsonResult QueryToJson(string QUERY, string ErrorReturn = null) { var model = new GenericReturn(); try { string connectionString = ConfigurationManager.ConnectionStrings["dbAttendance"].ConnectionString; using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand sqlCMD = new SqlCommand(QUERY, conn); conn.Open(); JavaScriptSerializer j = new JavaScriptSerializer(); model.data = j.Deserialize(sqlDatoToJson(sqlCMD.ExecuteReader()), typeof(object)); } } catch (Exception e) { if (ErrorReturn == null) { model.data = e.Message; } else { model.data = ErrorReturn; } } return(Json(model, JsonRequestBehavior.AllowGet)); }
static void WriteError(GenericReturn result) { if (result != GenericReturn.OK) { var format = string.Format("{0} :: Tracker Error -> {1}", DateTime.Now.ToString("g"), result); Trace.WriteLine(format); } }
public static GenericReturn AddMessage(this GenericReturn GenRet, params string[] messages) { foreach (var message in messages) { GenRet.messageList.Add(message); } return(GenRet); }
static void Main(string[] args) { var Program = new Program(); var Util = new GenericReturn(); Util.SetError(true) .AddMessage("hi") .AddMessage( "hi", "hello" ); Console.WriteLine(Util.error.ToString(), Util.messageList.FirstOrDefault()); Program.login(); }
static void WriteError(GenericReturn result) { if(result != GenericReturn.OK) { var format = string.Format("{0} :: Tracker Error -> {1}", DateTime.Now.ToString("g"), result); Trace.WriteLine(format); } }
public static GenericReturn AddMessage(this GenericReturn GenRet, string message) { GenRet.messageList.Add(message); return(GenRet); }
public static GenericReturn AddInfo(this GenericReturn GenRet, object info) { GenRet.info = info; return(GenRet); }
public static GenericReturn SetError(this GenericReturn GenRet, bool error) { GenRet.error = error; return(GenRet); }