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