public static List <clsCompanyInfo> GetAllCompanyInfo() { List <clsCompanyInfo> x = new List <clsCompanyInfo>(); using (SqlConnection conn = new SqlConnection(iShopClass.clsMain.sqlconnstring)) { conn.Open(); SqlCommand cmd = new SqlCommand("shop.spSelectAllCompanyInfo", conn); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { clsCompanyInfo y = new clsCompanyInfo(); y.ID = Convert.ToInt32(rdr["ID"]); y.CName = Convert.ToString(rdr["CName"]); y.Email = Convert.ToString(rdr["Email"]); y.Tel = Convert.ToString(rdr["Tel"]); y.Tin = Convert.ToString(rdr["Tin"]); y.STNO = Convert.ToString(rdr["STNO"]); y.CIN = Convert.ToString(rdr["CIN"]); y.CAddress = Convert.ToString(rdr["CAddress"]); //y.Flag = Convert.ToString(rdr["Flag"]); y.FileName = Convert.ToString(rdr["FileNamee"]); x.Add(y); } } return(x); }
public static int insert(clsCompanyInfo x) { using (SqlConnection conn = new SqlConnection(iShopClass.clsMain.sqlconnstring)) { conn.Open(); SqlCommand cmd = new SqlCommand("shop.spInsertCompanyInfo", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@cn", x.CName); cmd.Parameters.AddWithValue("@ca", x.CAddress); cmd.Parameters.AddWithValue("@tel", x.Tel); cmd.Parameters.AddWithValue("@em", x.Email); cmd.Parameters.AddWithValue("@tin", x.Tin); cmd.Parameters.AddWithValue("@stno", x.STNO); cmd.Parameters.AddWithValue("@cin", x.CIN); cmd.Parameters.AddWithValue("@flag", x.Image); cmd.Parameters.AddWithValue("@fn", x.FileName); int r = cmd.ExecuteNonQuery(); return(r); } }