protected override Java.Lang.Object DoInBackground(params Java.Lang.Object[] @params)
{
if (!CommonService.CheckInternetConnection(activity.Context))
{
return(null);
}
key = @params[0].ToString();
URL url = new URL(sqlquery_url);
string query = "";
if (key == "GetMenuByRestoID")
{
query = MenuResto.GetByRestoID(@params[1].ToString());
}
if (key == "GetMenuMakananByRestoID")
{
query = MenuResto.GetMenuMakananByRestoID(@params[1].ToString());
}
if (key == "GetMenuMinumanByRestoID")
{
query = MenuResto.GetMenuMinumanByRestoID(@params[1].ToString());
}
if (key == "GetMenuSpesialByRestoID")
{
query = MenuResto.GetMenuSpesialByRestoID(@params[1].ToString());
}
if (key == "GetMenuByIDInSelect")
{
query = MenuResto.GetMenuByIDInSelect(@params[1].ToString());
}
string data = URLEncoder.Encode("query", "UTF-8") + "=" + URLEncoder.Encode(query, "UTF-8");
HttpURLConnection urlConn = (HttpURLConnection)url.OpenConnection();
urlConn.RequestMethod = "POST";
urlConn.DoInput = true;
urlConn.DoOutput = true;
try
{
Stream oStream = urlConn.OutputStream;
BufferedWriter bw = new BufferedWriter(new OutputStreamWriter(oStream, "UTF-8"));
bw.Write(data);
bw.Flush();
bw.Close();
oStream.Close();
Stream iStream = urlConn.InputStream;
BufferedReader br = new BufferedReader(new InputStreamReader(iStream));
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
string line = "";
while ((line = br.ReadLine()) != null)
{
stringBuilder.Append(line + "\n");
}
urlConn.Disconnect();
string result = stringBuilder.ToString().Trim();
m_result = MenuResto.GetListByServerResponse(result);
return(result);
}
catch (Java.IO.IOException ex)
{
// Toast.MakeText(activity.GetContext(), ex.Message, ToastLength.Short);
}
return(null);
}
/// <summary>
/// login,getbyid
/// </summary>
/// <param name="params"></param>
/// <returns></returns>
protected override Java.Lang.Object DoInBackground(params Java.Lang.Object[] @params)
{
if (!CommonService.CheckInternetConnection(activity.GetContext()))
{
return(null);
}
key = @params[0].ToString();
URL url = new URL(sqlquery_url);
string query = "";
if (key == "login")
{
query = MrGo.Entity.Member.GetMemberByEmailPasswordSQL(@params[1].ToString(), @params[2].ToString());
}
if (key == "getbyid")
{
query = MrGo.Entity.Member.GetMemberByIdSQL(Convert.ToInt32(@params[1].ToString()));
}
if (key == "updateReSentCodeByEmail")
{
query = MrGo.Entity.Member.UpdateReSentCodeByEmail(@params[1].ToString());
}
if (key == "register")
{
url = new URL(sqlnonquery_url);
query = MrGo.Entity.Member.GetInsertSQL(
@params[1].ToString()
, @params[2].ToString()
, @params[3].ToString()
, @params[4].ToString()
, "1234"
);
}
if (key == "getbyemail")
{
query = MrGo.Entity.Member.GetMemberByEmail(@params[1].ToString());
}
if (key == "activateuser")
{
url = new URL(sqlnonquery_url);
query = MrGo.Entity.Member.GetActivateUserSQL(@params[1].ToString(), @params[2].ToString());
}
string data = URLEncoder.Encode("query", "UTF-8") + "=" + URLEncoder.Encode(query, "UTF-8");
HttpURLConnection urlConn = (HttpURLConnection)url.OpenConnection();
urlConn.RequestMethod = "POST";
urlConn.DoInput = true;
urlConn.DoOutput = true;
try
{
Stream oStream = urlConn.OutputStream;
BufferedWriter bw = new BufferedWriter(new OutputStreamWriter(oStream, "UTF-8"));
//string query = MrGo.Entity.Member.GetMemberByEmailPasswordSQL(@params[1].ToString(), @params[2].ToString());
bw.Write(data);
bw.Flush();
bw.Close();
oStream.Close();
Stream iStream = urlConn.InputStream;
BufferedReader br = new BufferedReader(new InputStreamReader(iStream));
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
string line = "";
while ((line = br.ReadLine()) != null)
{
stringBuilder.Append(line + "\n");
}
urlConn.Disconnect();
string result = stringBuilder.ToString().Trim();
Member = Member.GetByServerResponse(result);
return(result);
}
catch (Java.IO.IOException ex)
{
// Toast.MakeText(activity.GetContext(), ex.Message, ToastLength.Short);
}
return(null);
}
protected override Java.Lang.Object DoInBackground(params Java.Lang.Object[] @params)
{
if (!CommonService.CheckInternetConnection(activity.Context))
{
return(null);
}
key = @params[0].ToString();
URL url = new URL(sqlquery_url);
string query = "";
if (key == "InsertTransaction")
{
url = new URL(sqlnonquery_url);
Transaction tr = (Transaction)@params[1];
query = MrGo.Entity.Transaction.GetInsertSQL(tr);
}
if (key == "getmaxidbymember")
{
query = MrGo.Entity.Transaction.SelectMaxTransactionId(Convert.ToInt32(@params[1].ToString()));
}
if (key == "getmaxid")
{
query = MrGo.Entity.Transaction.SelectMaxTransactionId();
}
if (key == "InsertDetailsTransaction")
{
url = new URL(sqlnonquery_url);
TransactionDetail tr = (TransactionDetail)@params[1];
query = MrGo.Entity.TransactionDetail.GetInsertSQL(tr);
}
if (key == "getByMemberByStatus")
{
TransactionStatus trSts = (TransactionStatus)Enum.Parse(typeof(TransactionStatus), @params[1].ToString());
int trid = Convert.ToInt32(@params[2].ToString());
query = MrGo.Entity.Transaction.GetByMemberByStatusSQLSQL(trid, trSts);
}
if (key == "getByID")
{
int trId = Convert.ToInt32(@params[1].ToString());
query = MrGo.Entity.Transaction.GetByIDSQL(trId);
}
if (key == "getTrDetailByTrId")
{
int trId = Convert.ToInt32(@params[1].ToString());
query = MrGo.Entity.TransactionDetail.GetTrDetailByTrIdSQL(trId);
}
if (key == "updateStatus")
{
url = new URL(sqlnonquery_url);
TransactionStatus trSts = (TransactionStatus)Enum.Parse(typeof(TransactionStatus), @params[1].ToString());
int trId = Convert.ToInt32(@params[2].ToString());
query = MrGo.Entity.Transaction.UpDateStatusSQL(trId, trSts);
}
string data = URLEncoder.Encode("query", "UTF-8") + "=" + URLEncoder.Encode(query, "UTF-8");
HttpURLConnection urlConn = (HttpURLConnection)url.OpenConnection();
urlConn.RequestMethod = "POST";
urlConn.DoInput = true;
urlConn.DoOutput = true;
try
{
Stream oStream = urlConn.OutputStream;
BufferedWriter bw = new BufferedWriter(new OutputStreamWriter(oStream, "UTF-8"));
bw.Write(data);
bw.Flush();
bw.Close();
oStream.Close();
Stream iStream = urlConn.InputStream;
BufferedReader br = new BufferedReader(new InputStreamReader(iStream));
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
string line = "";
while ((line = br.ReadLine()) != null)
{
stringBuilder.Append(line + "\n");
}
urlConn.Disconnect();
string result = stringBuilder.ToString().Trim();
if (key == "getTrDetailByTrId")
{
m_result = TransactionDetail.GetListByServerResponse(result);
}
else
{
m_result = Transaction.GetListByServerResponse(result);
}
return(result);
}
catch (Java.IO.IOException ex)
{
// Toast.MakeText(activity.GetContext(), ex.Message, ToastLength.Short);
}
return(null);
}