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