Esempio n. 1
0
        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));
        }
Esempio n. 2
0
        public IHttpActionResult PutctblReceiver([FromBody] ctblReceiver ctblReceiver)
        {
            string  retvalue;
            cStatus status = new cStatus();

            try
            {
                string constr = ConfigurationManager.ConnectionStrings["MyAbDbContext"].ConnectionString;

                using (SqlConnection con = new SqlConnection(constr))
                {
                    SqlCommand cmd = new SqlCommand("sp_update_receiver", con);
                    cmd.CommandType = CommandType.StoredProcedure;

                    SqlParameter paramReceiverID = new SqlParameter();
                    paramReceiverID.ParameterName = "@ReceiverID";
                    paramReceiverID.Value         = ctblReceiver.ReceiverID;
                    cmd.Parameters.Add(paramReceiverID);

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

                    SqlParameter paramAddress = new SqlParameter();
                    paramAddress.ParameterName = "@Address";
                    paramAddress.Value         = ctblReceiver.Address;
                    cmd.Parameters.Add(paramAddress);


                    SqlParameter paramPOSTCODE = new SqlParameter();
                    paramPOSTCODE.ParameterName = "@POSTCODE";
                    paramPOSTCODE.Value         = ctblReceiver.POSTCODE;
                    cmd.Parameters.Add(paramPOSTCODE);

                    SqlParameter paramActiveUser = new SqlParameter();
                    paramActiveUser.ParameterName = "@ActiveUser";
                    paramActiveUser.Value         = ctblReceiver.ActiveUser;
                    cmd.Parameters.Add(paramActiveUser);

                    cmd.Parameters.Add("@LastupdatedID", SqlDbType.Int);
                    cmd.Parameters["@LastupdatedID"].Direction = ParameterDirection.Output;


                    con.Open();
                    cmd.ExecuteNonQuery();
                    con.Close();
                    retvalue        = cmd.Parameters["@LastupdatedID"].Value.ToString();
                    status.returnID = int.Parse(retvalue);
                    if (status.returnID == -2)
                    {
                        status.StatusID  = 1;
                        status.DesctoDev = "-2 is the error code for invalid POSTAL code. ";
                        status.StatusMsg = " Invalid POSTAL Code. ";
                    }
                    if (status.returnID >= 100000)
                    {
                        status.StatusID  = 0;
                        status.DesctoDev = "Store the returnID in Users Mobile database with UserType = R";
                        status.StatusMsg = " Listener Successfully Created/Updated ";
                    }
                }
            }
            catch (Exception ex)
            {
                retvalue = ex.Message.ToString();
            }


            return(Ok(status));
        }