public int ValidateUser(string emailid, string password) { context = new CodinovaDBContext(); int result = context.Database.SqlQuery <int>("Select [dbo].ufn_ValidateUser(@EmailId,@Password)", new SqlParameter("@EmailId", emailid), new SqlParameter("@Password", password)).First(); return(result); }
public int InsertSaleDetails(double?totalSaleAmount, string emailId, out int saleid) { int retvalue = 0; try { context = new CodinovaDBContext(); var saleidparam = new ObjectParameter("SaleId", typeof(int)); retvalue = context.usp_InsertSaleDetails(emailId, totalSaleAmount, saleidparam); saleid = Convert.ToInt32(saleidparam.Value); } catch (Exception ex) { Console.WriteLine(ex); saleid = 0; } return(retvalue); }
public List <POSSystem.Common.Product> GetAllProducts() { context = new CodinovaDBContext(); List <POSSystem.Common.Product> commonprodlist = new List <POSSystem.Common.Product>(); List <Product> prodlist; prodlist = (from p in context.Products select p).ToList <Product>(); foreach (Product prod in prodlist) { POSSystem.Common.Product p1 = new POSSystem.Common.Product() { ProductId = prod.ProductId, ProductName = prod.ProductName, Price = prod.Price, CategoryId = prod.CategoryId }; commonprodlist.Add(p1); } return(commonprodlist); }