public static company_master_modal select_id(int company_id)
{
My_Connection conn = new My_Connection();
SqlParameter [] p = new SqlParameter[1];
p[0] = new SqlParameter("@company_id", company_id);
DataSet ds = conn.select_id("sp_company_master_select_id", p);
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
else
{
DataRow dr = ds.Tables[0].Rows[0];
company_master_modal company = new company_master_modal();
company.company_id = int.Parse(dr["company_id"].ToString());
company.company_name = dr["company_name"].ToString();
company.company_status = Boolean.Parse(dr["company_status"].ToString());
return(company);
}
}
public static void insert_company(company_master_modal company)
{
My_Connection conn = new My_Connection();
SqlParameter[] p = new SqlParameter[2];
p[0] = new SqlParameter("@company_name", company.company_name);
p[1] = new SqlParameter("@company_status", company.company_status);
conn.insert("sp_company_master_insert", p);
}
public static void update(company_master_modal company)
{
My_Connection conn = new My_Connection();
SqlParameter [] p = new SqlParameter[3];
p[0] = new SqlParameter("@company_name", company.company_name);
p[1] = new SqlParameter("@company_status", company.company_status);
p[2] = new SqlParameter("@company_id", company.company_id);
conn.update("sp_company_master_update", p);
}
public static List <company_master_modal> select_all()
{
List <company_master_modal> li = new List <company_master_modal>();
My_Connection conn = new My_Connection();
DataSet ds = conn.select_all("sp_company_master_select_all");
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
company_master_modal company = new company_master_modal();
company.company_id = int.Parse(dr["company_id"].ToString());
company.company_name = dr["company_name"].ToString();
company.company_status = Boolean.Parse(dr["company_status"].ToString());
li.Add(company);
}
return(li);
}
