//DAL.onLocal();
// MySqlParameter[] param = new MySqlParameter[1];
//param[0] = new MySqlParameter("@idCar", int.Parse(idCar));
//DataTable data = DAL.SelectData("Call CarDetailsByIdCar(@idCar);", param);
public DataTable user_profileInsertUpdate(UserProfile_Model userProfile)
{
DataTable dt = new DataTable();
DAL2.onOnLine();
MySqlParameter[] param = new MySqlParameter[7];
param[0] = new MySqlParameter("@id", userProfile.id);
param[1] = new MySqlParameter("@username", userProfile.username);
param[2] = new MySqlParameter("@password", userProfile.password);
param[3] = new MySqlParameter("@roleUser", userProfile.roleUser);
param[4] = new MySqlParameter("@stateUser", userProfile.stateUser);
param[5] = new MySqlParameter("@dateValidate", userProfile.dateValidate);
param[6] = new MySqlParameter("@uuid", userProfile.uuid);
dt = DAL2.SelectData("CALL user_profileInsertUpdate( @id, @username,@password,@roleUser, @stateUser, @dateValidate, @uuid);", param);
return(dt);
}
public void orderCustomerInserUpdate(Order_Model order_Model)
{
DAL2.onOnLine();
MySqlParameter[] param = new MySqlParameter[11];
param[0] = new MySqlParameter("@id", order_Model.id);
param[1] = new MySqlParameter("@uuid", order_Model.uuid);
param[2] = new MySqlParameter("@customerName", order_Model.customerName);
param[3] = new MySqlParameter("@customerPhone", order_Model.customerPhone);
param[4] = new MySqlParameter("@address", order_Model.address);
param[5] = new MySqlParameter("@note", order_Model.note);
param[6] = new MySqlParameter("@order_general_deatils_uuid", order_Model.order_general_deatils_uuid);
param[7] = new MySqlParameter("@amount", order_Model.amount);
param[8] = new MySqlParameter("@uuidUser", order_Model.useruuid);
param[9] = new MySqlParameter("@dateCreated", order_Model.date);
param[10] = new MySqlParameter("@state", order_Model.state);
DAL2.ExcuCommane("CALL orderCustomerInserUpdate( @id, @uuid,@customerName,@customerPhone, @address, @note, @order_general_deatils_uuid,@amount,@uuidUser,@dateCreated,@state);", param);
}