public HttpResponseMessage RetailerLogin(tblRetailer retailer)
 {
     try
     {
         var result = db.proc_RetailLoginCheck(retailer.retaileremail, retailer.retailerpassword).ToList().Count();
         if (result == 1)
         {
             return(Request.CreateResponse(HttpStatusCode.OK, "valid"));
         }
         else
         {
             return(Request.CreateResponse(HttpStatusCode.OK, "invalid"));
         }
     }
     catch (Exception e)
     {
         return(Request.CreateErrorResponse(HttpStatusCode.OK, "invalid"));
     }
 }