public int GetInToParkingTurnMode(TicketForTurnModeDto ticket) { using (SqlConnection connection = new SqlConnection(Config.ConnectionString)) { try { connection.Open(); SqlCommand cmd = new SqlCommand("usp_get_in_turn_mode", connection) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.Add(new SqlParameter("@ticketId", ticket.ID)); cmd.Parameters.Add(new SqlParameter("@licsenPlate", ticket.LicensePlate)); cmd.Parameters.Add(new SqlParameter("@time", DateTime.Now)); cmd.Parameters.Add(new SqlParameter("@areaId", ticket.AreaID)); cmd.Parameters.Add(new SqlParameter("@vehicleType", ticket.VehicleType)); var returnParam = cmd.Parameters.Add("@result", SqlDbType.Int); returnParam.Direction = ParameterDirection.ReturnValue; cmd.ExecuteNonQuery(); int result = (int)returnParam.Value; if (result != 0) { return(Constants.RESULT_OK); } return(Constants.RESULT_ERROR); } catch (Exception e) { return(Constants.RESULT_ERROR); } } }
private void btnSubmit_Click(object sender, EventArgs e) { if (turnMode) { if (cbArea.SelectedIndex == -1 || cbType.SelectedIndex == -1 || tbTicketIdGen.Text.Equals("")) { MessageBox.Show("Vui lòng nhâp đầy đủ thông tin!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } TicketForTurnModeDto ticket = new TicketForTurnModeDto() { AreaID = cbArea.SelectedIndex + 1, ID = tbTicketIdGen.Text, LicensePlate = tbLicensePlate.Text, VehicleType = cbType.SelectedIndex + 1 }; int result = parkingDao.GetInToParkingTurnMode(ticket); if (result == Constants.RESULT_OK) { btnRefresh_Click(null, null); } else { MessageBox.Show("Có lỗi xảy ra!\nKhu vực đã hết chỗ!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { if (tbTicketIdInput.Text.Equals("") || tbCustomerName.Text.Equals("")) { return; } if (btnExtendTerm.Visible) { MessageBox.Show("Gia hạn trước khi vào bãi!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { int result = parkingDao.GetInToParkingTermMode(tbTicketIdInput.Text.Trim()); if (result == Constants.RESULT_OK) { btnRefresh_Click(null, null); } else { MessageBox.Show("Có lỗi xảy ra!\nKhu vực đã hết chỗ!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }