public string AddKhach(string intid, string name, string rank, int point, string bdate, string phone, int accid, string uname, string pass)
{
try
{
List <string> sql = new List <string>();
string query = "SET IDENTITY_INSERT Account ON;INSERT INTO Account(accountid,username,pass,typeAccount ) values(" + accid + ",'" +
uname + "','" +
pass + "','" +
"customer" +
"');SET IDENTITY_INSERT Account OFF;";
sql.Add(query);
string query2 = "insert into Users values(" + intid + ",'" +
name + "','" +
bdate + "','" +
phone + "','" +
point + "','" +
rank + "','" +
accid +
"')";
sql.Add(query2);
var a = db.Transaction(sql);
return(a.ToString());
}
catch (Exception e)
{
return(e.ToString());
}
}
//public int GetProviderName(int proid)
//{
// SqlConnection sqlcon = DBMain.Instance.GetSqlConnection();
// string sql = "select providerid from Providers where name =@name ";
// SqlCommand cmd = new SqlCommand(sql, sqlcon);
// cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = pro;
// return (int)cmd.ExecuteScalar();
//}
public string AddKho(string intid, string name, string type, string count, string intcost, string date, string intproid, ref string err)
{
try
{
string query = "insert into InputStore values(" + intid + ",'" +
name + "','" +
type + "'," +
count + "," +
intcost + ",'" +
date + "'," +
intproid +
")";
var a = db.Transaction(query);
return(a.ToString());
}
catch (Exception e)
{
return(e.ToString());
}
}
