コード例 #1
0
        public HttpResponseMessage CompleteConsignment(ConsignmentDetail objConsignmentDetail)
        {
            #region declaration
            DataTable dt     = new DataTable();
            string    sQuery = "";
            Random    r      = new Random();
            DBOperation.StructDBOperation[] objParam = new DBOperation.StructDBOperation[2];
            int iParamCount = 0;
            #endregion

            DBOperation.sConnectionString = ec.Decrypt(GlobalClass.sConnectionString);

            objParam[iParamCount].sParamName  = "@vQueryType";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = "UPDATELOADSTATUS";
            iParamCount++;

            objParam[iParamCount].sParamName  = "@vFilterClause";
            objParam[iParamCount].sParamType  = SqlDbType.Int;
            objParam[iParamCount].sParamValue = Convert.ToString(objConsignmentDetail.CId);
            iParamCount++;


            sQuery  = "ProcGetOfferConsignment";
            sRetVal = DBOperation.ExecuteDBOperation(sQuery, DBOperation.OperationType.STOREDPROC_UPDATE, objParam, ref dt);
            if (sRetVal == "SUCCESS")
            {
                return(Request.CreateResponse(HttpStatusCode.OK, "Consignment Completed Successfully"));
            }
            else
            {
                return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Please Contact Administrator with below mentioned error " + sRetVal));
            }
        }
コード例 #2
0
        /// Function Name : Reject Bid Details
        /// Parameter Details
        /// 1. BidDetail DTO
        ///
        /// Functionality
        /// This function accept Bid details DTO and mark the bid as rejected based on the Bid ID
        ///
        public HttpResponseMessage RejectBid(BidDetail objBidDetail)
        {
            #region declaration
            DataTable dt     = new DataTable();
            string    sQuery = "";
            Random    r      = new Random();
            DBOperation.StructDBOperation[] objParam = new DBOperation.StructDBOperation[2];
            int iParamCount = 0;
            #endregion

            DBOperation.sConnectionString = ec.Decrypt(GlobalClass.sConnectionString);

            objParam[iParamCount].sParamName  = "@vQueryType";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = "REJECTBID";
            iParamCount++;

            objParam[iParamCount].sParamName  = "@bid";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = Convert.ToString(objBidDetail.BidID);
            iParamCount++;


            sQuery  = ProcBidOperation_Bid;
            sRetVal = DBOperation.ExecuteDBOperation(sQuery, DBOperation.OperationType.STOREDPROC_UPDATE, objParam, ref dt);
            if (sRetVal == "SUCCESS")
            {
                return(Request.CreateResponse(HttpStatusCode.OK, "Bid Rejected Successfully"));
            }
            else
            {
                return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Please Contact Administrator with below mentioned error " + sRetVal));
            }
        }
コード例 #3
0
        public HttpResponseMessage ValidateOTP(UserLogin objUserOTP)
        {
            #region Declaration
            string    sRetVal = "";
            DataTable dt      = null;

            #endregion

            try
            {
                if (long.Equals(objUserOTP.lMobileNo, null) || objUserOTP.lMobileNo.Equals(""))
                {
                    return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Mobile Number can't be blank"));
                }

                DBOperation.sConnectionString = ec.Decrypt(GlobalClass.sConnectionString);
                DBOperation.StructDBOperation[] structDBOperation = new DBOperation.StructDBOperation[3];

                structDBOperation[0].sParamName  = "@vQueryType";
                structDBOperation[0].sParamType  = SqlDbType.VarChar;
                structDBOperation[0].sParamValue = "GETUSEROTPDETAILS";

                structDBOperation[1].sParamName  = "@iMobileNo";
                structDBOperation[1].sParamType  = SqlDbType.BigInt;
                structDBOperation[1].sParamValue = Convert.ToString(objUserOTP.lMobileNo);

                structDBOperation[2].sParamName  = "@iMobileOTP";
                structDBOperation[2].sParamType  = SqlDbType.Int;
                structDBOperation[2].sParamValue = Convert.ToString(objUserOTP.iUserOTP);

                sRetVal = DBOperation.ExecuteDBOperation("ProcUserLogin", DBOperation.OperationType.STOREDPROC, structDBOperation, ref dt);

                if (sRetVal == "SUCCESS")
                {
                    //Logs.StoreActivityLogsInDB(LogType.Login, GlobalData.iUserID, "Logged in successfully.", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.Name, System.Reflection.MethodBase.GetCurrentMethod().Name);
                    if (dt != null && dt.Rows.Count > 0)
                    {
                        return(Request.CreateResponse(HttpStatusCode.OK, "Mobile No Verified Successfully"));
                    }
                    else
                    {
                        return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Mobile OTP doesn't match."));
                    }
                }

                return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Please Contact Administrator with below mentioned error " + sRetVal));
            }
            catch (Exception ex)
            {
                return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Please Contact Administrator with below mentioned error " + ex.Message));
            }
        }
コード例 #4
0
        public string ValidateUser(string sUserName, string sPassword)
        {
            //string strQuery = "";
            string    sRetVal = "";
            DataTable dt      = null;

            try
            {
                DBOperation.StructDBOperation[] structDBOperation = new DBOperation.StructDBOperation[2];

                structDBOperation[0].sParamName  = "@vQueryType";
                structDBOperation[0].sParamType  = SqlDbType.VarChar;
                structDBOperation[0].sParamValue = "GETUSERDETAILS";

                structDBOperation[1].sParamName  = "@vUserName";
                structDBOperation[1].sParamType  = SqlDbType.VarChar;
                structDBOperation[1].sParamValue = sUserName;

                sRetVal = DBOperation.ExecuteDBOperation("ProcGetUserInfo", DBOperation.OperationType.STOREDPROC, structDBOperation, ref dt);

                if (sRetVal == "SUCCESS")
                {
                    if (dt != null && dt.Rows.Count > 0)
                    {
                        if (Convert.ToString(dt.Rows[0]["Password"]) != sPassword)
                        {
                            return("Invalid Username or password.");
                        }
                        return("SUCCESS");
                    }
                    else
                    {
                        return("Invalid Username or password.");
                    }
                }

                return(sRetVal);
            }
            catch (Exception ex)
            {
                return(ex.Message);
            }
        }
コード例 #5
0
        public HttpResponseMessage UpdateConsignment(ConsignmentDetail objConsignmentDetail)
        {
            #region declaration
            DataTable dt     = new DataTable();
            string    sQuery = "";
            Random    r      = new Random();
            DBOperation.StructDBOperation[] objParam = new DBOperation.StructDBOperation[11];
            int iParamCount = 0;
            #endregion

            DBOperation.sConnectionString = ec.Decrypt(GlobalClass.sConnectionString);

            objParam[iParamCount].sParamName  = "@vQueryType";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = "UPDATELOAD";
            iParamCount++;

            objParam[iParamCount].sParamName  = "@iLoadId";
            objParam[iParamCount].sParamType  = SqlDbType.Int;
            objParam[iParamCount].sParamValue = Convert.ToString(objConsignmentDetail.CId);
            iParamCount++;

            objParam[iParamCount].sParamName  = "@iUserId";
            objParam[iParamCount].sParamType  = SqlDbType.Int;
            objParam[iParamCount].sParamValue = Convert.ToString(objConsignmentDetail.UserID);
            iParamCount++;

            objParam[iParamCount].sParamName  = "@vDepartureCity";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = objConsignmentDetail.DepartureCity;
            iParamCount++;

            objParam[iParamCount].sParamName  = "@vDestinationCity";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = objConsignmentDetail.DestinationCity;
            iParamCount++;

            objParam[iParamCount].sParamName  = "@dStartDate";
            objParam[iParamCount].sParamType  = SqlDbType.DateTime;
            objParam[iParamCount].sParamValue = objConsignmentDetail.CStartDate.ToString("MM-dd-yyyy hh:mm:ss");;
            iParamCount++;

            objParam[iParamCount].sParamName  = "@vMaterial";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = objConsignmentDetail.Cmaterial;
            iParamCount++;

            objParam[iParamCount].sParamName  = "@fApproximateWeight";
            objParam[iParamCount].sParamType  = SqlDbType.Float;
            objParam[iParamCount].sParamValue = Convert.ToString(objConsignmentDetail.ApproximateWeight);
            iParamCount++;

            objParam[iParamCount].sParamName  = "@dApproximateBudget";
            objParam[iParamCount].sParamType  = SqlDbType.Float;
            objParam[iParamCount].sParamValue = Convert.ToString(objConsignmentDetail.ApproximateBudget);
            iParamCount++;

            objParam[iParamCount].sParamName  = "@bLoading";
            objParam[iParamCount].sParamType  = SqlDbType.Bit;
            objParam[iParamCount].sParamValue = objConsignmentDetail.Loading ? "1" : "0";
            iParamCount++;

            objParam[iParamCount].sParamName  = "@bUnLoading";
            objParam[iParamCount].sParamType  = SqlDbType.Bit;
            objParam[iParamCount].sParamValue = objConsignmentDetail.UnLoading ? "1" : "0";
            iParamCount++;

            sQuery  = "ProcOfferConsignment";
            sRetVal = DBOperation.ExecuteDBOperation(sQuery, DBOperation.OperationType.STOREDPROC_UPDATE, objParam, ref dt);
            if (sRetVal == "SUCCESS")
            {
                return(Request.CreateResponse(HttpStatusCode.OK, "Consignment Updated Successfully"));
            }
            else
            {
                return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Please Contact Administrator with below mentioned error " + sRetVal));
            }
        }
コード例 #6
0
        public HttpResponseMessage GetConsignmentDetail(ConsignmentDetail objConsignmentDetail)
        {
            #region declaration
            DataTable dt     = new DataTable();
            string    sQuery = "";
            Random    r      = new Random();
            DBOperation.StructDBOperation[] objParam = new DBOperation.StructDBOperation[2];
            int    iParamCount = 0;
            string sFilter     = "";
            #endregion

            DBOperation.sConnectionString = ec.Decrypt(GlobalClass.sConnectionString);
            #region Prepare Query Filter

            if (objConsignmentDetail.CId > 0)
            {
                sFilter += " AND load_id=" + objConsignmentDetail.CId;
            }

            if (objConsignmentDetail.UserID > 0)
            {
                sFilter += " AND user_id=" + objConsignmentDetail.UserID;
            }

            if (!string.IsNullOrEmpty(objConsignmentDetail.DepartureCity))
            {
                sFilter += " AND load_departure_city=" + "'" + objConsignmentDetail.DepartureCity + "'";
            }

            if (!string.IsNullOrEmpty(objConsignmentDetail.DestinationCity))
            {
                sFilter += " AND load_destination_city=" + "'" + objConsignmentDetail.DestinationCity + "'";
            }

            if (objConsignmentDetail.CStartDate > DateTime.MinValue)
            {
                sFilter += " AND load_departure_city>=" + "'" + objConsignmentDetail.CStartDate + "'";
            }

            if (sFilter.Length > 4)
            {
                sFilter = "Where " + sFilter.Substring(4);
            }
            else
            {
                sFilter = null;
            }

            #endregion
            objParam[iParamCount].sParamName  = "@vQueryType";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = "GETCONSIGNMENTDETAIL";
            iParamCount++;

            objParam[iParamCount].sParamName  = "@vFilterClause";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = sFilter;
            iParamCount++;


            sQuery  = "ProcGetOfferConsignment";
            sRetVal = DBOperation.ExecuteDBOperation(sQuery, DBOperation.OperationType.STOREDPROC, objParam, ref dt);
            if (sRetVal == "SUCCESS")
            {
                return(Request.CreateResponse(HttpStatusCode.OK, dt));
            }
            else
            {
                return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Please Contact Administrator with below mentioned error " + sRetVal));
            }
        }
コード例 #7
0
        //***************************************** Place Bid **************************************************
        //      PlaceBid     :   Place the bid for a specific consignment                                       *
        //      GetBidDetail :   Get the bid detail on the basis of different filter Crieteria                  *
        //      UpdateBid    :   Update Bid Details. Only Bid amount can modify                                 *
        //      DeleteBid    :   Delete bid on the basis of bid ID                                              *
        //
        //*******************************************************************************************************

        /// Function Name : Place Bid
        /// Parameter Details
        /// 1. BidDetail DTO
        ///
        /// Functionality
        /// This function accept Bid details DTO and store into DB
        /// Value of Load ID, User ID, Amount is mandatory

        public HttpResponseMessage PlaceBid(BidDetail objBidDetail)
        {
            #region declaration
            DataTable dt     = new DataTable();
            string    sQuery = "";
            Random    r      = new Random();
            DBOperation.StructDBOperation[] objParam = new DBOperation.StructDBOperation[9];
            int iParamCount = 0;
            #endregion


            DBOperation.sConnectionString = ec.Decrypt(GlobalClass.sConnectionString);

            objParam[iParamCount].sParamName  = "@vQueryType";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = "PLACEBID";
            iParamCount++;

            objParam[iParamCount].sParamName  = "@bid";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = "0";
            iParamCount++;

            objParam[iParamCount].sParamName  = "@cid";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = Convert.ToString(objBidDetail.CId);
            iParamCount++;

            objParam[iParamCount].sParamName  = "@bidamount";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = Convert.ToString(objBidDetail.BidAmount);
            iParamCount++;

            objParam[iParamCount].sParamName  = "@userid";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = Convert.ToString(objBidDetail.UserID);
            iParamCount++;

            objParam[iParamCount].sParamName  = "@viewed";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = objBidDetail.Viewed;
            iParamCount++;

            objParam[iParamCount].sParamName  = "@status";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = Convert.ToString(objBidDetail.Status);
            iParamCount++;

            objParam[iParamCount].sParamName  = "@creationdatetime";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = Convert.ToString(objBidDetail.CreationDateTime.ToString("dd-MM-yyyy"));
            iParamCount++;

            objParam[iParamCount].sParamName  = "@BidUpdateDateTime";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = Convert.ToString(objBidDetail.BidUpdateDateTime.ToString("dd-MM-yyyy"));;
            iParamCount++;

            sQuery  = "ProcBidOperation";
            sRetVal = DBOperation.ExecuteDBOperation(sQuery, DBOperation.OperationType.STOREDPROC_UPDATE, objParam, ref dt);
            if (sRetVal == "SUCCESS")
            {
                return(Request.CreateResponse(HttpStatusCode.OK, "Bid Placed Successfully"));
            }
            else
            {
                return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Please Contact Administrator with below mentioned error " + sRetVal));
            }
        }
コード例 #8
0
        public HttpResponseMessage GetBidDetail(BidDetail objBidDetail)
        {
            #region declaration
            DataTable dt     = new DataTable();
            string    sQuery = "";
            Random    r      = new Random();
            DBOperation.StructDBOperation[] objParam = new DBOperation.StructDBOperation[2];
            int    iParamCount = 0;
            string sFilter     = "";
            #endregion

            DBOperation.sConnectionString = ec.Decrypt(GlobalClass.sConnectionString);

            #region Prepare Query Filter
            if (objBidDetail.BidID > 0)
            {
                sFilter += " AND bid_id=" + objBidDetail.BidID;
            }
            if (objBidDetail.CId > 0)
            {
                sFilter += " AND load_id=" + objBidDetail.CId;
            }
            if (objBidDetail.BidAmount > 0)
            {
                sFilter += " AND Bid_Amount=" + objBidDetail.BidAmount;
            }
            if (objBidDetail.UserID > 0)
            {
                sFilter += " AND User_ID=" + objBidDetail.UserID;
            }
            if (!string.IsNullOrEmpty(objBidDetail.Viewed))
            {
                sFilter += " AND Viewed=" + objBidDetail.Viewed;
            }

            if (sFilter.Length > 4)
            {
                sFilter = "Where " + sFilter.Substring(4);
            }
            #endregion

            objParam[iParamCount].sParamName  = "@vQueryType";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = "CONSIGNMENTDETAIL";
            iParamCount++;

            objParam[iParamCount].sParamName  = "@vFilterClause";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = sFilter;
            iParamCount++;


            sQuery  = "ProcGetBidDetail";
            sRetVal = DBOperation.ExecuteDBOperation(sQuery, DBOperation.OperationType.STOREDPROC, objParam, ref dt);
            if (sRetVal == "SUCCESS")
            {
                return(Request.CreateResponse(HttpStatusCode.OK, dt));
            }
            else
            {
                return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Please Contact Administrator with below mentioned error " + sRetVal));
            }
        }
コード例 #9
0
        //***************************************** User Login **************************************************
        //      UserLogin   :   Login/Signup user with mobile number                                            *
        //      ValidateOTP :   Validate register mobile number with OTP                                        *
        //      UpdateUserPreference    :   Update user preference of user i.e. Company Owner/ Fleet Owner      *
        //                                                                                                      *
        //*******************************************************************************************************

        public HttpResponseMessage UserLogin(UserLogin objUserLogin)
        {
            try
            {
                #region declaration
                DataTable dt     = new DataTable();
                string    sQuery = "";
                Random    r      = new Random();
                DBOperation.sConnectionString = ec.Decrypt(GlobalClass.sConnectionString);
                DBOperation.StructDBOperation[] objParam = new DBOperation.StructDBOperation[3];
                int    iParamCount = 0;
                string sMobile_OTP = "";

                #endregion

                #region validation

                if (long.Equals(objUserLogin.lMobileNo, null) || objUserLogin.lMobileNo.Equals(""))
                {
                    return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Mobile Number can't be blank"));
                }


                #endregion

                #region DataBase Entry and Response


                if ((objUserLogin.lMobileNo != 0))
                {
                    r           = new Random();
                    sMobile_OTP = r.Next().ToString();
                    sMobile_OTP = sMobile_OTP.PadLeft(6, '0');
                    sMobile_OTP = sMobile_OTP.Substring(0, 6);
                    sendSMS(objUserLogin.lMobileNo, "Your OTP for " + GlobalClass.sCompanyName + " is " + sMobile_OTP);
                }


                objParam[iParamCount].sParamName  = "@vQueryType";
                objParam[iParamCount].sParamType  = SqlDbType.VarChar;
                objParam[iParamCount].sParamValue = "USERLOGIN";
                iParamCount++;


                objParam[iParamCount].sParamName  = "@iMobileNo";
                objParam[iParamCount].sParamType  = SqlDbType.BigInt;
                objParam[iParamCount].sParamValue = Convert.ToString(objUserLogin.lMobileNo);
                iParamCount++;


                objParam[iParamCount].sParamName  = "@iMobileOTP";
                objParam[iParamCount].sParamType  = SqlDbType.Int;
                objParam[iParamCount].sParamValue = sMobile_OTP;
                iParamCount++;

                sQuery  = "ProcUserLogin";
                sRetVal = DBOperation.ExecuteDBOperation(sQuery, DBOperation.OperationType.STOREDPROC_UPDATE, objParam, ref dt);
                if (sRetVal == "SUCCESS")
                {
                    return(Request.CreateResponse(HttpStatusCode.OK, "SUCCESS"));
                }
                else
                {
                    return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Please Contact Administrator with below mentioned error " + sRetVal));
                }
                #endregion
            }
            catch (Exception e1)
            {
                return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Please Contact Administrator with below mentioned error " + e1.Message));
            }
        }
コード例 #10
0
        //***************************************** User Info **************************************************
        //      UserInfo  :   Insert User Info                                             *
        //      ValidateOTP :   Validate register mobile number with OTP                                        *
        //      UpdateUserPreference    :   Update user preference of user i.e. Company Owner/ Fleet Owner      *
        //                                                                                                      *
        //*******************************************************************************************************



        public HttpResponseMessage UpdateUserInfo(UserInfo objUserInfo)
        {
            #region declaration
            DataTable dt          = new DataTable();
            string    sQuery      = "";
            Random    r           = new Random();
            int       iParamCount = 0;
            #endregion

            DBOperation.sConnectionString = ec.Decrypt(GlobalClass.sConnectionString);
            DBOperation.StructDBOperation[] objParam = new DBOperation.StructDBOperation[8];



            objParam[iParamCount].sParamName  = "@vQueryType";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = "USERINFO";
            iParamCount++;

            objParam[iParamCount].sParamName  = "@iuser_id";
            objParam[iParamCount].sParamType  = SqlDbType.Int;
            objParam[iParamCount].sParamValue = Convert.ToString(objUserInfo.iUserId);
            iParamCount++;

            objParam[iParamCount].sParamName  = "@vuser_name";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = objUserInfo.sUser_Name;
            iParamCount++;

            objParam[iParamCount].sParamName  = "@vuser_email_id";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = objUserInfo.sEmailID;
            iParamCount++;

            objParam[iParamCount].sParamName  = "@vuser_address";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = objUserInfo.sUser_Address;
            iParamCount++;

            objParam[iParamCount].sParamName  = "@iuser_zip";
            objParam[iParamCount].sParamType  = SqlDbType.Int;
            objParam[iParamCount].sParamValue = Convert.ToString(objUserInfo.sUser_Zip);
            iParamCount++;

            objParam[iParamCount].sParamName  = "@vuser_gst_pan";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = objUserInfo.sUser_Gst_Pan;
            iParamCount++;

            objParam[iParamCount].sParamName  = "@vuser_company_name";
            objParam[iParamCount].sParamType  = SqlDbType.VarChar;
            objParam[iParamCount].sParamValue = objUserInfo.sCompany_Name;
            iParamCount++;

            sQuery  = "ProcUserInfo";
            sRetVal = DBOperation.ExecuteDBOperation(sQuery, DBOperation.OperationType.STOREDPROC_UPDATE, objParam, ref dt);
            if (sRetVal == "SUCCESS")
            {
                return(Request.CreateResponse(HttpStatusCode.OK, "User Info Updated Successfully"));
            }
            else
            {
                return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Please Contact Administrator with below mentioned error " + sRetVal));
            }
        }
コード例 #11
0
        public HttpResponseMessage UpdateUserPreference(UserLogin objUserLogin)
        {
            try
            {
                #region declaration
                DataTable dt = new DataTable();

                Random r = new Random();
                DBOperation.sConnectionString = ec.Decrypt(GlobalClass.sConnectionString);
                DBOperation.StructDBOperation[] objParam = new DBOperation.StructDBOperation[3];
                int iParamCount = 0;


                #endregion

                #region validation

                if (long.Equals(objUserLogin.lMobileNo, null) || objUserLogin.lMobileNo.Equals(""))
                {
                    return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Mobile Number can't be blank"));
                }


                #endregion

                #region DataBase Entry and Response

                objParam[iParamCount].sParamName  = "@vQueryType";
                objParam[iParamCount].sParamType  = SqlDbType.VarChar;
                objParam[iParamCount].sParamValue = "UPDATEPREFERENCE";
                iParamCount++;


                objParam[iParamCount].sParamName  = "@iMobileNo";
                objParam[iParamCount].sParamType  = SqlDbType.BigInt;
                objParam[iParamCount].sParamValue = Convert.ToString(objUserLogin.lMobileNo);
                iParamCount++;


                objParam[iParamCount].sParamName = "@iUserPreference";
                objParam[iParamCount].sParamType = SqlDbType.Int;

                objParam[iParamCount].sParamValue = Convert.ToString(objUserLogin.iUserPreference);
                iParamCount++;


                sRetVal = DBOperation.ExecuteDBOperation("ProcUserLogin", DBOperation.OperationType.STOREDPROC_UPDATE, objParam, ref dt);
                if (sRetVal == "SUCCESS")
                {
                    return(Request.CreateResponse(HttpStatusCode.OK, "SUCCESS"));
                }
                else
                {
                    return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Please Contact Administrator with below mentioned error " + sRetVal));
                }
                #endregion
            }
            catch (Exception e1)
            {
                return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "Please Contact Administrator with below mentioned error " + e1.Message));
            }
        }