//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); }