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