public int UpdateCheckingScrap(SqlConnection connection, CheckingScrapViewModel user) { int result = 0; using (var command = new SqlCommand("ins_CheckingScrap_Update " + "@CheckingScrapId," + "@OutHourGuard," + "@OutGateId," + "@User5Id," + "@IsDone," + "@Step" , connection)) { AddSqlParameter(command, "@CheckingScrapId", user.CheckingScrapId, System.Data.SqlDbType.UniqueIdentifier); AddSqlParameter(command, "@OutHourGuard", user.OutHourGuard, System.Data.SqlDbType.DateTime); AddSqlParameter(command, "@OutGateId", user.OutGateId, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@User5Id", user.User5Id, System.Data.SqlDbType.UniqueIdentifier); AddSqlParameter(command, "@IsDone", user.IsDone, System.Data.SqlDbType.Bit); AddSqlParameter(command, "@Step", user.Step, System.Data.SqlDbType.Int); WriteLogExecutingCommand(command); using (var reader = command.ExecuteReader()) { while (reader.Read()) { var info = new GateViewModel(); result = GetDbReaderValue <int>(reader["result"]); } } } return(result); }
public ActionMessage SaveCheckingScrapIn([FromHeader] string key, [FromHeader] string token, [FromBody] SaveVehicleViewModel input, Guid userID) { if (Encrypt.checkToken(token, key)) { ActionMessage ret = new ActionMessage(); var item = CheckingScrapService.GetInstance().GetCheckingScrap(input.RFID, false); if (item.Count > 0) { ret.isSuccess = false; ret.err.msgCode = "Internal Error !!!"; ret.err.msgString = string.Format("Thẻ này đang được sử dụng cho xe: \"{0}\"!", item.FirstOrDefault().VehicleNumber); } else { var checkingModel = new CheckingScrapViewModel(); checkingModel.CheckingScrapId = Guid.NewGuid(); checkingModel.User1Id = userID; checkingModel.InHourGuard = DateTime.Now; checkingModel.RFID = input.RFID.Replace("http://", ""); checkingModel.VehicleNumber = input.BienSoXe; checkingModel.DriverName = input.TenTaiXe; checkingModel.DriverIdCard = input.CMND; checkingModel.GiaoNhan = input.GiaoNhan; checkingModel.InGateId = input.SelectedGate; checkingModel.Note1 = input.Note; checkingModel.Step = ConstantStepKL._1VAOCONG; checkingModel.IsDone = false; int result = CheckingScrapService.GetInstance().InsertCheckingScrap(checkingModel); return((result == 1) ? new ActionMessage { isSuccess = false, err = new ErorrMssage { msgCode = "Internal Error !!!", msgString = string.Format("Quét thẻ thành công! Mời xe : \"{0}\" vào !", checkingModel.VehicleNumber), } } : new ActionMessage { isSuccess = false, err = new ErorrMssage { msgCode = "Internal Error !!!", msgString = "Quét thẻ thất bại", } }); } return(ret); } else { ActionMessage ret = new ActionMessage(); ret.isSuccess = false; ret.err.msgCode = "Internal Error !!!"; ret.err.msgString = "Key hoặc token không chính xác"; return(ret); } }
public int UpdateCheckingScrap(CheckingScrapViewModel _user) { ConnectionFactory sqlConnection = new ConnectionFactory(); CheckingScrapViewModel record = new CheckingScrapViewModel(); using (SqlConnection connection = sqlConnection.GetConnection()) { return(CheckingScrapDatalayer.GetInstance().UpdateCheckingScrap(connection, _user)); } }
public List <CheckingScrapViewModel> GetCheckingScrap(SqlConnection connection, string RFID, bool isDone) { var result = new List <CheckingScrapViewModel>(); using (var command = new SqlCommand("exec Ins_CheckingScrapModel_GetByRFID @RFID, @isDone", connection)) { AddSqlParameter(command, "@RFID", RFID, System.Data.SqlDbType.VarChar); AddSqlParameter(command, "@isDone", isDone, System.Data.SqlDbType.Bit); using (var reader = command.ExecuteReader()) { while (reader.Read()) { var info = new CheckingScrapViewModel(); info.CheckingScrapId = GetDbReaderValue <Guid>(reader["CheckingScrapId"]); info.ChekingScrapIdInt = GetDbReaderValue <int>(reader["ChekingScrapIdInt"]); info.ScaleTicketId = GetDbReaderValue <Guid>(reader["ScaleTicketId"]); info.ScaleTicketMobileId = GetDbReaderValue <Guid>(reader["ScaleTicketMobileId"]); info.RFID = GetDbReaderValue <string>(reader["RFID"]); info.InHourGuard = GetDbReaderValue <DateTime>(reader["InHourGuard"]); info.OutHourGuard = GetDbReaderValue <DateTime>(reader["OutHourGuard"]); info.GiaoNhan = GetDbReaderValue <string>(reader["GiaoNhan"]); info.VehicleNumber = GetDbReaderValue <string>(reader["VehicleNumber"]); info.DriverName = GetDbReaderValue <string>(reader["DriverName"]); info.DriverIdCard = GetDbReaderValue <string>(reader["DriverIdCard"]); info.IsVehicleNew = GetDbReaderValue <bool>(reader["IsVehicleNew"]); info.InGateId = GetDbReaderValue <string>(reader["InGateId"]); info.OutGateId = GetDbReaderValue <string>(reader["OutGateId"]); info.ReceiveType = GetDbReaderValue <string>(reader["ReceiveType"]); info.User1Id = GetDbReaderValue <Guid>(reader["User1Id"]); info.Note1 = GetDbReaderValue <string>(reader["Note1"]); info.User2Id = GetDbReaderValue <Guid>(reader["User2Id"]); info.User3Id = GetDbReaderValue <Guid>(reader["User3Id"]); info.Note3 = GetDbReaderValue <string>(reader["Note3"]); info.CheckingTime = GetDbReaderValue <DateTime>(reader["CheckingTime"]); info.User4Id = GetDbReaderValue <Guid>(reader["User4Id"]); info.VerifyTime = GetDbReaderValue <DateTime>(reader["VerifyTime"]); info.User5Id = GetDbReaderValue <Guid>(reader["User5Id"]); info.Status = GetDbReaderValue <int>(reader["Status"]); info.Actived = GetDbReaderValue <bool>(reader["Actived"]); info.IsDone = GetDbReaderValue <bool>(reader["IsDone"]); info.Step = GetDbReaderValue <int>(reader["Step"]); result.Add(info); } } return(result); } }
public int InsertCheckingScrap(SqlConnection connection, CheckingScrapViewModel user) { int result = 0; using (var command = new SqlCommand("EXEC Ins_CheckingScrap_Insert " + "@CheckingScrapId," + "@ScaleTicketId," + "@ScaleTicketMobileId," + "@RFID," + "@InHourGuard," + "@OutHourGuard," + "@GiaoNhan," + "@VehicleNumber," + "@DriverName," + "@DriverIdCard," + "@IsVehicleNew," + "@InGateId," + "@OutGateId," + "@ReceiveType," + "@User1Id," + "@Note1," + "@User2Id," + "@User3Id," + "@Note3," + "@CheckingTime," + "@User4Id," + "@VerifyTime," + "@User5Id," + "@Status," + "@Actived," + "@IsDone," + "@Step" , connection)) { AddSqlParameter(command, "@CheckingScrapId", user.CheckingScrapId, System.Data.SqlDbType.UniqueIdentifier); AddSqlParameter(command, "@ScaleTicketId", user.ScaleTicketId, System.Data.SqlDbType.UniqueIdentifier); AddSqlParameter(command, "@ScaleTicketMobileId", user.ScaleTicketMobileId, System.Data.SqlDbType.UniqueIdentifier); AddSqlParameter(command, "@RFID", user.RFID, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@InHourGuard", user.InHourGuard, System.Data.SqlDbType.DateTime); AddSqlParameter(command, "@OutHourGuard", user.OutHourGuard, System.Data.SqlDbType.DateTime); AddSqlParameter(command, "@GiaoNhan", user.GiaoNhan, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@VehicleNumber", user.VehicleNumber, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@DriverName", user.DriverName, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@DriverIdCard", user.DriverIdCard, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@IsVehicleNew", user.IsVehicleNew, System.Data.SqlDbType.Bit); AddSqlParameter(command, "@InGateId", user.InGateId, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@OutGateId", user.OutGateId, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@ReceiveType", user.ReceiveType, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@User1Id", user.User1Id, System.Data.SqlDbType.UniqueIdentifier); AddSqlParameter(command, "@Note1", user.Note1, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@User2Id", user.User2Id, System.Data.SqlDbType.UniqueIdentifier); AddSqlParameter(command, "@User3Id", user.User3Id, System.Data.SqlDbType.UniqueIdentifier); AddSqlParameter(command, "@Note3", user.Note3, System.Data.SqlDbType.NVarChar); AddSqlParameter(command, "@CheckingTime", user.CheckingTime, System.Data.SqlDbType.DateTime); AddSqlParameter(command, "@User4Id", user.User4Id, System.Data.SqlDbType.UniqueIdentifier); AddSqlParameter(command, "@VerifyTime", user.VerifyTime, System.Data.SqlDbType.DateTime); AddSqlParameter(command, "@User5Id", user.User5Id, System.Data.SqlDbType.UniqueIdentifier); AddSqlParameter(command, "@Status", user.Status, System.Data.SqlDbType.Int); AddSqlParameter(command, "@Actived", user.Actived, System.Data.SqlDbType.Bit); AddSqlParameter(command, "@IsDone", user.IsDone, System.Data.SqlDbType.Bit); AddSqlParameter(command, "@Step", user.Step, System.Data.SqlDbType.Int); WriteLogExecutingCommand(command); using (var reader = command.ExecuteReader()) { while (reader.Read()) { var info = new GateViewModel(); result = GetDbReaderValue <int> (reader["result"]); } } } return(result); }