public bool Insert(ProductInfo obj) { var da = new SqlDbDataAccess(); SqlCommand cmd = da.GetCommand( "INSERT INTO [dbo].[Product] ([Pname],[price],[quan],[unit]) VALUES (@pname, @price, @quan,@unit)"); var p1 = new SqlParameter("@Pname", SqlDbType.VarChar, 50) {Value = obj.Pname}; var p2 = new SqlParameter("@price", SqlDbType.VarChar, 50) {Value = obj.Price}; var p3 = new SqlParameter("@quan", SqlDbType.Int) {Value = obj.Quan}; var p4 = new SqlParameter("@unit", SqlDbType.VarChar) {Value = obj.Unit}; cmd.Parameters.Add(p1); cmd.Parameters.Add(p2); cmd.Parameters.Add(p3); cmd.Parameters.Add(p4); cmd.Connection.Open(); int val = cmd.ExecuteNonQuery(); cmd.Connection.Close(); return val > 0; }
public bool Insert(TransInfo obj) { var da = new SqlDbDataAccess(); SqlCommand cmd = da.GetCommand( "INSERT INTO [dbo].[Trans] ([Pname],[quan],[tprice],[date]) VALUES (@pname, @quan,@price, @date)"); var p1 = new SqlParameter("@Pname", SqlDbType.VarChar, 50) {Value = obj.Pname}; var p2 = new SqlParameter("@quan", SqlDbType.Int) {Value = obj.Quan}; var p3 = new SqlParameter("@price", SqlDbType.Float) {Value = obj.Tprice}; var p4 = new SqlParameter("@date", SqlDbType.VarChar, 50) {Value = obj.Date}; cmd.Parameters.Add(p1); cmd.Parameters.Add(p2); cmd.Parameters.Add(p3); cmd.Parameters.Add(p4); cmd.Connection.Open(); int val = cmd.ExecuteNonQuery(); cmd.Connection.Close(); return val > 0; }
public List<TransInfo> GetTransInfo() { var da = new SqlDbDataAccess(); SqlCommand cmd = da.GetCommand("SELECT * from Trans"); List<TransInfo> transList = GetData(cmd); return transList; }
public List<ProductInfo> GetProductInfo() { var da = new SqlDbDataAccess(); SqlCommand cmd = da.GetCommand("SELECT * from Product"); List<ProductInfo> productList = GetData(cmd); return productList; }
public List<TransInfo> GetTransInfoByName(String pname) { var da = new SqlDbDataAccess(); SqlCommand cmd = da.GetCommand("SELECT * FROM Trans WHERE Pname lik '%@Pname%'"); var p1 = new SqlParameter("@Pname", SqlDbType.VarChar, 50) {Value = pname}; cmd.Parameters.Add(p1); List<TransInfo> transList = GetData(cmd); return transList; }
public DataTable GetUserInfoTable() { var da = new SqlDbDataAccess(); SqlCommand cmd = da.GetCommand("SELECT * from Userinfo"); var dt = new SqlDataAdapter(cmd); cmd.Connection.Open(); var tbl = new DataTable(); dt.Fill(tbl); cmd.Connection.Close(); return tbl; }
public List<ProductInfo> GetProductInfoByName(String Pname) { var da = new SqlDbDataAccess(); SqlCommand cmd = da.GetCommand("SELECT * FROM Product WHERE Pname =@Pname "); var p1 = new SqlParameter("@Pname", SqlDbType.VarChar, 50) {Value = Pname}; cmd.Parameters.Add(p1); List<ProductInfo> productList = GetData(cmd); return productList; }
public List<UserInfo> GetuserInfo(String uname, string pass) { var da = new SqlDbDataAccess(); SqlCommand cmd = da.GetCommand("SELECT * FROM Userinfo WHERE uname = @uname and pass = @pass"); var p1 = new SqlParameter("@uname", SqlDbType.VarChar, 50) {Value = uname}; var p2 = new SqlParameter("@pass", SqlDbType.VarChar, 50) {Value = pass}; cmd.Parameters.Add(p1); cmd.Parameters.Add(p2); List<UserInfo> user = GetData(cmd); return user; }
public DataTable GetGpriceByDate(DateTime date) { var da = new SqlDbDataAccess(); SqlCommand cmd = da.GetCommand("SELECT SUM(tprice) AS total FROM Trans WHERE date =@date"); var p1 = new SqlParameter("@date", SqlDbType.VarChar, 50) {Value = date}; cmd.Parameters.Add(p1); var dt = new SqlDataAdapter(cmd); cmd.Connection.Open(); var tbl = new DataTable(); dt.Fill(tbl); cmd.Connection.Close(); return tbl; }
public bool Delete(int id) { var da = new SqlDbDataAccess(); SqlCommand cmd = da.GetCommand("DELETE FROM [dbo].[Product] WHERE id=@id"); var p1 = new SqlParameter("@id", SqlDbType.VarChar, 50) {Value = id}; cmd.Parameters.Add(p1); cmd.Connection.Open(); int val = cmd.ExecuteNonQuery(); cmd.Connection.Close(); return val > 0; }
public bool Insert(UserInfo obj) { var da = new SqlDbDataAccess(); SqlCommand cmd = da.GetCommand("INSERT INTO [dbo].[Userinfo] ([uname],[pass]) VALUES (@uname, @pass)"); var p1 = new SqlParameter("@uname", SqlDbType.VarChar, 50) {Value = obj.Uname}; var p2 = new SqlParameter("@pass", SqlDbType.VarChar, 50) {Value = obj.Pass}; cmd.Parameters.Add(p1); cmd.Parameters.Add(p2); cmd.Connection.Open(); int val = cmd.ExecuteNonQuery(); cmd.Connection.Close(); return val > 0; }
public bool UpdateQuan(string price, int id, int quan, String unit) { var da = new SqlDbDataAccess(); SqlCommand cmd = da.GetCommand("update [dbo].[Product] SET quan = @quan,price=@price,unit=@unit WHERE id = @id"); var p1 = new SqlParameter("@price", SqlDbType.VarChar, 50) {Value = price}; var p2 = new SqlParameter("@quan", SqlDbType.Int) {Value = quan}; var p3 = new SqlParameter("@id", SqlDbType.Int) {Value = id}; var p4 = new SqlParameter("@unit", SqlDbType.VarChar, 50) {Value = unit}; cmd.Parameters.Add(p1); cmd.Parameters.Add(p2); cmd.Parameters.Add(p3); cmd.Parameters.Add(p4); cmd.Connection.Open(); int val = cmd.ExecuteNonQuery(); cmd.Connection.Close(); return val > 0; }