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