public static List <clsBilling> selectAll()
{
List <clsBilling> x = new List <clsBilling>();
using (SqlConnection conn = new SqlConnection(sqlconnstring))
{
conn.Open();
SqlCommand cmd = new SqlCommand("shop.spSelectAllBilling", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
clsBilling y = new clsBilling();
y.ID = Convert.ToInt32(rdr["ID"]);
y.InvoiceNo = Convert.ToString(rdr["InvoiceNo"]);
y.InvoiceDate = Convert.ToDateTime(rdr["InvoiceDate"]);
y.Product = Convert.ToString(rdr["PartName"]);
y.FullName = Convert.ToString(rdr["FullName"]);
y.Amount = Convert.ToInt32(rdr[@"Amount\Qty"]);
y.PaymentMethod = Convert.ToString(rdr["PaymentMethod"]);
y.IsInCart = Convert.ToBoolean(rdr["IsInCart"]);
y.Remarks = Convert.ToString(rdr["Remarks"]);
x.Add(y);
}
}
return(x);
}
public static int insert(clsBilling x)
{
using (SqlConnection conn = new SqlConnection(sqlconnstring))
{
conn.Open();
SqlCommand cmd = new SqlCommand("shop.spInsertBilling", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ivno", x.InvoiceNo);
cmd.Parameters.AddWithValue("@ivdate", x.InvoiceDate);
cmd.Parameters.AddWithValue("@pid", x.PID);
cmd.Parameters.AddWithValue("@cid", x.CID);
cmd.Parameters.AddWithValue("@qty", x.Amount);
cmd.Parameters.AddWithValue("@pm", x.PaymentMethod);
cmd.Parameters.AddWithValue("@is", x.IsInCart);
cmd.Parameters.AddWithValue("@rem", x.Remarks);
int r = cmd.ExecuteNonQuery();
return(r);
}
}