Example #1
0
        public int Update(string Otp)
        {
            int result = 0;

            try
            {
                string  sql = "Update Otp SET IsUsed = 1 WHERE GeneratedOtp = @Otp";
                MSQconn c   = new MSQconn(ConString);
                c.SetSQL(sql);
                c.AddParam("@Otp", Otp);
                var resp = c.Update();
                result = Convert.ToInt32(resp);
            }
            catch (Exception ex)
            {
            }
            return(result);
        }
Example #2
0
        public bool SetPanicFinger(string PanicFingerPsoition, string BVN)
        {
            //update the panic finger
            string  sql = "update Customer set PanicFinger=@PanicFinger where BVN =@BVN and  Status=1";
            MSQconn con = new MSQconn(ConString);

            con.SetSQL(sql);
            con.AddParam("@BVN", BVN);
            int resp = con.Update();

            if (resp == 1)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }