public static company getComapnyData(int id)
{
DataBase db = new DataBase();
DataTable dt = new DataTable();
string sql = "select * from CompanysTable where CompanyId = " + id;
dt = db.ExecuteReader(sql);
company company = new company();
company.CompanyId = id;
company.CompanyName = dt.Rows[0]["CompanyName"].ToString();
company.logo = dt.Rows[0]["logo"].ToString();
company.contact = dt.Rows[0]["contact"].ToString();
company.siteAddress = dt.Rows[0]["siteAddress"].ToString();
company.apiAddress = dt.Rows[0]["apiAddress"].ToString();
company.remarks = dt.Rows[0]["remarks"].ToString();
return(company);
}
public static int saveCompany(company company)
{
DataBase db = new DataBase();
string sql;
if (company.CompanyId == 0)
{
sql = "insert into CompanysTable (CompanyName,Logo,Contact,SiteAddress,ApiAddress,Remarks) values ('" + company.CompanyName + "','" + company.logo + "','" + company.contact + "','" + company.siteAddress + "','" + company.apiAddress + "','" + company.remarks + "')";
}
else
{
sql = "update CompanysTable set CompanyName = '" + company.CompanyName + "',Logo = '" + company.logo + "',Contact = '" + company.contact + "',SiteAddress = '" + company.siteAddress + "',ApiAddress = '" + company.apiAddress + "',Remarks = '" + company.remarks + "' where CompanyId = " + company.CompanyId;
}
int successFlag = db.ExecuteNonQuery(sql);
if (successFlag > 0)
{
return(db.GetMaxId("CompanysTable", "CompanyId"));
}
return(-1);
}