public static List <clsDebtors> GetAllDebtors()
{
List <clsDebtors> x = new List <clsDebtors>();
using (SqlConnection conn = new SqlConnection(clsMain.sqlconnstring))
{
conn.Open();
SqlCommand cmd = new SqlCommand("shop.spSelectAllDebtors", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
clsDebtors y = new clsDebtors();
y.ID = Convert.ToInt32(rdr["ID"]);
y.DebtorNO = Convert.ToString(rdr["DebtorNO"]);
y.DebtorDate = Convert.ToDateTime(rdr["DebtorDate"]);
y.Product = Convert.ToString(rdr["PartName"]);
y.FName = Convert.ToString(rdr["FName"]);
y.SName = Convert.ToString(rdr["SName"]);
y.Email = Convert.ToString(rdr["Email"]);
y.Tel = Convert.ToString(rdr["Tel"]);
y.CAddress = Convert.ToString(rdr["CAddress"]);
y.Qty = Convert.ToInt32(rdr["Qty"]);
y.IsPaid = Convert.ToBoolean(rdr["IsPaid"]);
y.PRemarks = Convert.ToString(rdr["PRemarks"]);
y.DRemarks = Convert.ToString(rdr["DRemarks"]);
y.Flag = Convert.ToString(rdr["Flag"]);
x.Add(y);
}
}
return(x);
}
public static int insert(clsDebtors x)
{
using (SqlConnection conn = new SqlConnection(clsMain.sqlconnstring))
{
conn.Open();
SqlCommand cmd = new SqlCommand("shop.spInsertDebtors", conn);
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@dn", x.DebtorNO);
cmd.Parameters.AddWithValue("@dd", x.DebtorDate);
cmd.Parameters.AddWithValue("@p", x.PID);
cmd.Parameters.AddWithValue("@fn", x.FName);
cmd.Parameters.AddWithValue("@ln", x.SName);
cmd.Parameters.AddWithValue("@e", x.Email);
cmd.Parameters.AddWithValue("@t", x.Tel);
cmd.Parameters.AddWithValue("@c", x.CAddress);
cmd.Parameters.AddWithValue("@q", x.Qty);
cmd.Parameters.AddWithValue("@i", x.IsPaid);
cmd.Parameters.AddWithValue("@r", x.DRemarks);
cmd.Parameters.AddWithValue("@f", x.Flag);
int r = cmd.ExecuteNonQuery();
return(r);
}
}
