public GetAllTokensResp GetAllTokens()
{
GetAllTokensResp res = new GetAllTokensResp();
string[] tokens = null;
SqlResModel selectTokens = SqlDbHelper.SelectWithParam(ConstantManager.EOneConnString(), "proc_GetAllTokens", CommandType.StoredProcedure, null);
if (selectTokens.ResponseCode == "00" && selectTokens.ResultDataTable.Rows.Count > 0)
{
for (int i = 0; i < selectTokens.ResultDataTable.Rows.Count; i++)
{
tokens[i] = Convert.ToString(selectTokens.ResultDataTable.Rows[i]["TokenId"]);
}
res.ResponseCode = "00";
res.ResponseDescription = "successful";
}
else
{
res.ResponseCode = "01";
res.ResponseDescription = "failed";
}
res.Tokens = tokens;
return(res);
}
public static SqlResModel SelectWithParam(string ConnString, string CommandName, CommandType cmdType, SqlParameter[] param = null)
{
string classMeth = "SelectWithParam ";
DataTable ds = new DataTable();
var res = new SqlResModel();
using (SqlConnection con = new SqlConnection(ConnString))
{
using (SqlCommand cmd = con.CreateCommand())
{
try
{
cmd.CommandType = cmdType;
cmd.CommandText = CommandName;
cmd.Parameters.Clear();
if (param != null)
{
cmd.Parameters.AddRange(param);
}
if (con.State != ConnectionState.Open)
{
con.Open();
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
res.ResponseCode = "00";
}
}
catch (Exception ex)
{
ErrHandler.Log(classMeth + "Error occured while executing " + CommandName + " " + ex.Message + " " + ex.StackTrace);
res.ResponseCode = "99";
}
cmd.Parameters.Clear();
}
}
res.ResultDataTable = ds;
return(res);
}
public static SqlResModel UpdateWithParam(string ConnString, string CommandName, CommandType commandType, SqlParameter[] param)
{
string classMeth = "UpdateWithParam";
int result = 0;
var res = new SqlResModel();
using (SqlConnection con = new SqlConnection(ConnString))
{
using (SqlCommand cmd = con.CreateCommand())
{
try
{
cmd.CommandType = commandType;
cmd.CommandText = CommandName;
cmd.Parameters.AddRange(param);
if (con.State != ConnectionState.Open)
{
con.Open();
}
result = cmd.ExecuteNonQuery();
ErrHandler.Log("The response from check Session is " + result);
result = Math.Abs(result);
ErrHandler.Log("result - " + result);
res.ResponseCode = "00";
}
catch (Exception ex)
{
ErrHandler.Log(classMeth + "Error occured while executing " + CommandName + " " + ex.Message + " " + ex.StackTrace);
result = 0;
res.ResponseCode = "99";
}
}
}
res.ResultInt = result;
return(res);
}
public PushNotifResp PushNotification(PushNotifReq pushNotifReq)
{
PushNotifResp resp = new PushNotifResp();
try
{
if (string.IsNullOrEmpty(pushNotifReq.PrevToken))
{
//Insert
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("@CustomerId", pushNotifReq.CustomerId),
new SqlParameter("@Browser", pushNotifReq.Browser),
new SqlParameter("@Channel", pushNotifReq.Channel),
new SqlParameter("@Device", pushNotifReq.Device),
new SqlParameter("@NotificationType", pushNotifReq.NotificationType),
new SqlParameter("@Topic", pushNotifReq.Topic),
new SqlParameter("@CustomerType", pushNotifReq.CustomerType),
new SqlParameter("@Token", pushNotifReq.Token),
};
SqlResModel insertToken = SqlDbHelper.InsertWithParam(ConstantManager.EOneConnString(), "proc_InsertToken", CommandType.StoredProcedure, sqlParams);
if (insertToken.ResponseCode == "00" && insertToken.ResultInt > 0)
{
resp.ResponseCode = "00";
resp.TokenCount = insertToken.ResultInt;
resp.ResponseDescription = "successful";
}
else
{
resp.ResponseCode = "01";
resp.TokenCount = insertToken.ResultInt;
resp.ResponseDescription = "failed";
}
}
else
{
//select
SqlParameter[] sqlParam = new SqlParameter[]
{
new SqlParameter("@PrevToken", pushNotifReq.PrevToken),
};
SqlResModel selectToken = SqlDbHelper.SelectWithParam(ConstantManager.EOneConnString(), "proc_GetPrevToken", CommandType.StoredProcedure, sqlParam);
//if record exist - update
if (selectToken.ResponseCode == "00" && selectToken.ResultDataTable.Rows.Count > 0)
{
SqlParameter[] sqlParam1 = new SqlParameter[]
{
new SqlParameter("@Token", pushNotifReq.Token),
new SqlParameter("@PrevToken", pushNotifReq.PrevToken),
};
SqlResModel updateToken = SqlDbHelper.SelectWithParam(ConstantManager.EOneConnString(), "proc_UpdateToken", CommandType.StoredProcedure, sqlParam1);
if (updateToken.ResultInt > 0 && updateToken.ResponseCode == "00")
{
resp.ResponseCode = "00";
resp.TokenCount = updateToken.ResultInt;
resp.ResponseDescription = "successful";
}
else
{
resp.ResponseCode = "01";
resp.TokenCount = updateToken.ResultInt;
resp.ResponseDescription = "failed";
}
}
else
{
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("@CustomerId", pushNotifReq.CustomerId),
new SqlParameter("@Browser", pushNotifReq.Browser),
new SqlParameter("@Channel", pushNotifReq.Browser),
new SqlParameter("@Device", pushNotifReq.Device),
new SqlParameter("@NotificationType", pushNotifReq.NotificationType),
new SqlParameter("@Topic", pushNotifReq.Topic),
new SqlParameter("@CustomerType", pushNotifReq.CustomerType),
new SqlParameter("@Token", pushNotifReq.Token),
};
SqlResModel insertToken = SqlDbHelper.InsertWithParam(ConstantManager.EOneConnString(), "proc_InsertToken", CommandType.StoredProcedure, sqlParams);
if (insertToken.ResponseCode == "00" && insertToken.ResultInt > 0)
{
resp.ResponseCode = "00";
resp.TokenCount = insertToken.ResultInt;
resp.ResponseDescription = "successful";
}
else
{
resp.ResponseCode = "01";
resp.TokenCount = insertToken.ResultInt;
resp.ResponseDescription = "failed";
}
}
}
}
catch (Exception ex)
{
ErrHandler.Log(pushNotifReq.CustomerId + " Error encounterd: " + ex.Message + " " + ex.StackTrace);
resp.ResponseCode = "99";
resp.ResponseDescription = "Exception thrown";
}
resp.CustomerId = pushNotifReq.CustomerId;
return(resp);
}
public PushNotifResp SendPushNotification(SendPushNotifReq req)
{
PushNotifResp res = new PushNotifResp();
//Send Notif here
var tokens = req.Tokens;
var pushSent = PushNotificationLogic.SendPushNotification(tokens, req.MesssageTitle, req.MesssageBody, req.Image).Result;
if (pushSent)
{
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("@Title", req.MesssageTitle),
new SqlParameter("@Body", req.MesssageBody),
new SqlParameter("@Image", req.Image),
new SqlParameter("@SentStatus", 1),
};
SqlResModel insertToken = SqlDbHelper.InsertWithParam(ConstantManager.EOneConnString(), "proc_InsertPushMessage", CommandType.StoredProcedure, sqlParams);
if (insertToken.ResponseCode == "00" && insertToken.ResultInt > 0)
{
ErrHandler.Log("Push Notification Sent and logged successfully on PUshMessages DB for target token Ids");
}
else
{
ErrHandler.Log("Push Notification successfully Sent to target token Ids but an error occured while trying to log the Message on PushMessages DB");
}
res.ResponseCode = "00";
res.ResponseDescription = "successful";
res.TokenCount = tokens.Length;
res.CustomerId = req.CustomerId;
res.SentStatus = 1;
}
else
{
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("@Title", req.MesssageTitle),
new SqlParameter("@Body", req.MesssageBody),
new SqlParameter("@Image", req.Image),
new SqlParameter("@SentStatus", 0),
};
SqlResModel insertToken = SqlDbHelper.InsertWithParam(ConstantManager.EOneConnString(), "proc_InsertPushMessage", CommandType.StoredProcedure, sqlParams);
if (insertToken.ResponseCode == "00" && insertToken.ResultInt > 0)
{
ErrHandler.Log("Failed to send Push Notification for target token Ids. Messages details has been logged to the PushMessages DB");
}
else
{
ErrHandler.Log("Failed in logging Message details for the failed Push Notification");
}
res.ResponseCode = "01";
res.ResponseDescription = "failed";
res.TokenCount = 0;
res.CustomerId = req.CustomerId;
res.SentStatus = 0;
}
return(res);
}
