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