//this function to send parameters to sql from add products
public void addp(string idp, string labelp, int qt, string pr, byte[] img, int idc)
{
LaunchOmatic.DAL.DataacsessLayer DAL = new LaunchOmatic.DAL.DataacsessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@idp", SqlDbType.VarChar, 50);
param[0].Value = idp;
param[1] = new SqlParameter("@labelp", SqlDbType.VarChar, 50);
param[1].Value = labelp;
param[2] = new SqlParameter("@qt", SqlDbType.Int);
param[2].Value = qt;
param[3] = new SqlParameter("@pr", SqlDbType.VarChar, 50);
param[3].Value = pr;
param[4] = new SqlParameter("@img", SqlDbType.Image);
param[4].Value = img;
param[5] = new SqlParameter("@idc", SqlDbType.Int);
param[5].Value = idc;
DAL.Executecommand("addp", param);
DAL.Close();
}
public void addu(string cname, string PWD, string uname, string country, string email, byte[] img)
{
LaunchOmatic.DAL.DataacsessLayer DAL = new LaunchOmatic.DAL.DataacsessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@cname", SqlDbType.NVarChar, 50);
param[0].Value = cname;
param[1] = new SqlParameter("@pwd", SqlDbType.NVarChar, 50);
param[1].Value = PWD;
param[2] = new SqlParameter("@uname", SqlDbType.NVarChar, 50);
param[2].Value = uname;
param[3] = new SqlParameter("@country", SqlDbType.NVarChar, 50);
param[3].Value = country;
param[4] = new SqlParameter("@email", SqlDbType.NVarChar, 50);
param[4].Value = email;
param[5] = new SqlParameter("@img", SqlDbType.Image);
param[5].Value = img;
DAL.Executecommand("addnewaccount", param);
DAL.Close();
}
public DataTable gcm()
{
LaunchOmatic.DAL.DataacsessLayer DAL = new LaunchOmatic.DAL.DataacsessLayer();
DataTable dt = new DataTable();
dt = DAL.selectdata("gcm", null);
return(dt);
}
public void Deletep(string @ID)
{
LaunchOmatic.DAL.DataacsessLayer DAL = new LaunchOmatic.DAL.DataacsessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.VarChar, 50);
param[0].Value = ID;
DAL.Executecommand("Deletep", param);
DAL.Close();
}
public DataTable deleteu(string ID)
{
LaunchOmatic.DAL.DataacsessLayer DAL = new LaunchOmatic.DAL.DataacsessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.NVarChar, 50);
param[0].Value = ID;
DataTable dt = new DataTable();
dt = DAL.selectdata("deleteu", param);
return(dt);
}
public DataTable searchu(string habd)
{
LaunchOmatic.DAL.DataacsessLayer DAL = new LaunchOmatic.DAL.DataacsessLayer();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@habd", SqlDbType.NVarChar, 50);
param[0].Value = habd;
DataTable dt = new DataTable();
dt = DAL.selectdata("searchu", param);
return(dt);
}
public DataTable Searchp(string s)
{
LaunchOmatic.DAL.DataacsessLayer DAL = new LaunchOmatic.DAL.DataacsessLayer();
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@s", SqlDbType.NVarChar, 4000);
param[0].Value = s;
dt = DAL.selectdata("serachinallcolumns", param);
return(dt);
}
public DataTable Login(string uname, String PWD)
{
LaunchOmatic.DAL.DataacsessLayer DAL = new LaunchOmatic.DAL.DataacsessLayer();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter(@"uname", SqlDbType.NVarChar, 50);
param[0].Value = uname;
param[1] = new SqlParameter(@"PWD", SqlDbType.NVarChar, 50);
param[1].Value = PWD;
DataTable dt = new DataTable();
dt = DAL.selectdata("confirmlog", param);
return(dt);
}
public void uh(DateTime date, string maker, string payload, string sor3tintlaq, string engine, string dest, string fuelsys, string live, string payloadratio, string bestplacetoview, string descreption)
{
LaunchOmatic.DAL.DataacsessLayer DAL = new LaunchOmatic.DAL.DataacsessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[11];
param[0] = new SqlParameter("@date", SqlDbType.DateTime);
param[0].Value = date;
param[1] = new SqlParameter("@maker", SqlDbType.NVarChar, 50);
param[1].Value = maker;
param[2] = new SqlParameter("@payload", SqlDbType.NVarChar, 4000);
param[2].Value = payload;
param[3] = new SqlParameter("@sor3tintlaq", SqlDbType.NVarChar, 4000);
param[3].Value = sor3tintlaq;
param[4] = new SqlParameter("@engine", SqlDbType.NVarChar, 4000);
param[4].Value = engine;
param[5] = new SqlParameter("@dest", SqlDbType.NVarChar, 4000);
param[5].Value = dest;
param[6] = new SqlParameter("@fuelsys", SqlDbType.NVarChar, 4000);
param[6].Value = fuelsys;
param[7] = new SqlParameter("@live", SqlDbType.NVarChar, 4000);
param[7].Value = live;
param[8] = new SqlParameter("@payloadratio", SqlDbType.NVarChar, 4000);
param[8].Value = payloadratio;
param[9] = new SqlParameter("@bestpkacetoview", SqlDbType.NVarChar, 4000);
param[9].Value = bestplacetoview;
param[10] = new SqlParameter("@descreption", SqlDbType.NVarChar, 4000);
param[10].Value = descreption;
DAL.Executecommand("uh", param);
DAL.Close();
}
public void editu(string ID, string PWD, string ACSESS, string FN)
{
LaunchOmatic.DAL.DataacsessLayer DAL = new LaunchOmatic.DAL.DataacsessLayer();
DAL.Open();
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@ID", SqlDbType.NVarChar, 50);
param[0].Value = ID;
param[1] = new SqlParameter("@PWD", SqlDbType.NVarChar, 50);
param[1].Value = PWD;
param[2] = new SqlParameter("@ACSESS", SqlDbType.NVarChar, 50);
param[2].Value = ACSESS;
param[3] = new SqlParameter("@FN", SqlDbType.NVarChar, 50);
param[3].Value = FN;
DAL.Executecommand("editu", param);
DAL.Close();
}
