public string AddOtp(string phonenum, string otp)
{
var str = "could not add otp";
try
{
var findobj = (from c in context.Otp
where c.Phoneno == phonenum
select c).FirstOrDefault();
if (findobj == null)
{
var obj = new Otp();
obj.Otpstring = otp;
obj.Phoneno = phonenum;
obj.CreatedDate = DateTime.Now;
context.Otp.Add(obj);
context.SaveChanges();
str = "sucessfully added otp";
}
else
{
findobj.Otpstring = otp;
findobj.CreatedDate = DateTime.Now;
using (var newContext = new StuffyCareContext())
{
newContext.Otp.Update(findobj);
newContext.SaveChanges();
str = "OTP updated sucessfully";
}
}
}
catch (Exception e)
{
str = e.Message;
throw e;
}
return(str);
}
public string UpdateCart(Cart cart)
{
string status = "could not update try again";
try
{
Cart carti = (from c in context.Cart
where c.Userid == cart.Userid && c.Itemid == cart.Itemid
select c).FirstOrDefault();
carti.Quantity = cart.Quantity;
using (var newContext = new StuffyCareContext())
{
newContext.Cart.Update(carti);
newContext.SaveChanges();
status = "updated sucessfuly";
}
}
catch (Exception e)
{
status = "exception occured in Dal";
throw e;
}
return(status);
}
public string UpdateServices(Vendorservices services)
{
string status = "could not update try again";
try
{
Vendorservices carti = (from c in context.Vendorservices
where c.Vendorid == services.Vendorid && c.Name == services.Name
select c).FirstOrDefault();
carti.Price = services.Price;
using (var newContext = new StuffyCareContext())
{
newContext.Vendorservices.Update(carti);
newContext.SaveChanges();
status = "updated sucessfuly";
}
}
catch (Exception e)
{
status = "exception occured in Dal";
throw e;
}
return(status);
}
public UserDAOImpl()
{
context = new StuffyCareContext();
}
public VendorDAOImpl()
{
context = new StuffyCareContext();
}
