public async Task PostFCMResponse(string fcmresponse, string message, string successFlag)
{
cStatusStr status = new cStatusStr();
try
{
string constr = ConfigurationManager.ConnectionStrings["MyAbDbContext"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
SqlCommand cmd = new SqlCommand("sp_fcmresponse", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter paramfcmresponsee = new SqlParameter();
paramfcmresponsee.ParameterName = "@fcmResponse";
paramfcmresponsee.Value = fcmresponse;
cmd.Parameters.Add(paramfcmresponsee);
SqlParameter parammessage = new SqlParameter();
parammessage.ParameterName = "@message";
parammessage.Value = message;
cmd.Parameters.Add(parammessage);
SqlParameter paramsuccessflag = new SqlParameter();
paramsuccessflag.ParameterName = "@successflag";
paramsuccessflag.Value = successFlag;
cmd.Parameters.Add(paramsuccessflag);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
//status.returnID = int.Parse(retvalue);
}
}
catch (Exception ex)
{
status.StatusMsg = ex.Message.ToString();
status.StatusID = "1";
}
}
public async Task <IHttpActionResult> PostctblReceiver([FromBody] ctblReceiver ctblReceiver)
{
cStatusStr status = new cStatusStr();
string retvalue;
try
{
string constr = ConfigurationManager.ConnectionStrings["MyAbDbContext"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
SqlCommand cmd = new SqlCommand("sp_new_receiver", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter paramRecName = new SqlParameter();
paramRecName.ParameterName = "@ReceiverName";
paramRecName.Value = ctblReceiver.ReceiverName;
cmd.Parameters.Add(paramRecName);
SqlParameter paramRecPhone = new SqlParameter();
paramRecPhone.ParameterName = "@ReceiverPhone";
paramRecPhone.Value = ctblReceiver.ReceiverPhone;
cmd.Parameters.Add(paramRecPhone);
if (ctblReceiver.deviceTokenID == null)
{
ctblReceiver.deviceTokenID = "Assigned by API";
}
SqlParameter paramRecdeviceTokenID = new SqlParameter();
paramRecdeviceTokenID.ParameterName = "@IME";
paramRecdeviceTokenID.Value = ctblReceiver.deviceTokenID;
cmd.Parameters.Add(paramRecdeviceTokenID);
SqlParameter paramRecSIMNO = new SqlParameter();
paramRecSIMNO.ParameterName = "@SIMNO";
paramRecSIMNO.Value = ctblReceiver.SIMNO;
cmd.Parameters.Add(paramRecSIMNO);
SqlParameter paramPOSTCODE = new SqlParameter();
paramPOSTCODE.ParameterName = "@POSTCODE";
paramPOSTCODE.Value = ctblReceiver.POSTCODE;
cmd.Parameters.Add(paramPOSTCODE);
cmd.Parameters.Add("@LastInsertedID", SqlDbType.Int);
cmd.Parameters["@LastInsertedID"].Direction = ParameterDirection.Output;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
retvalue = cmd.Parameters["@LastInsertedID"].Value.ToString();
status.returnID = retvalue;
//status.returnID = int.Parse(retvalue);
if (status.returnID.Equals("-5")) //(status.returnID==-5)
{
status.StatusID = "1";
status.DesctoDev = "Restricted LISTENER NAME ";
status.StatusMsg = " Restricted LISTENER NAME ";
}
if (status.returnID.Equals("-2")) //(status.returnID==-2)
{
status.StatusID = "1";
status.DesctoDev = "-2 is the error code for invalid POSTAL code. ";
status.StatusMsg = " Invalid POSTAL Code. ";
}
if (int.Parse(status.returnID) >= 100000) /// (status.returnID >=100000)
{
status.StatusID = "0";
status.DesctoDev = "Store the returnID in Users Mobile database with UserType = R";
status.StatusMsg = " Listener Successfully Created/Updated ";
status.userType = "R";
}
}
}
catch (Exception ex)
{
status.StatusMsg = ex.Message.ToString();
status.StatusID = "1";
}
return(Ok(status));
}