private bool deleteCarTag_Tag(int carId) { bool result = false; int id; id = carId; Common.BLL.Entity.GasStation.CarTag model = new Common.BLL.Entity.GasStation.CarTag() { carId = id }; Common.BLL.Logic.GasStation.CarTag lCarTag = new Common.BLL.Logic.GasStation.CarTag(Common.Enum.EDatabase.GasStation); CommandResult resultCarTag = lCarTag.read(model, "carId"); if (resultCarTag.status == BaseDAL.Base.EnumCommandStatus.success) { // Delete CarTag int tagId = model.tagId; CommandResult opResult = lCarTag.delete(model); if (opResult.status == BaseDAL.Base.EnumCommandStatus.success) { //Delete Tag from tabel Tarffic Common.BLL.Entity.GasStation.Traffic modelTraffic = new Common.BLL.Entity.GasStation.Traffic() { tagId = tagId }; Common.BLL.Logic.GasStation.Traffic lTraffic = new Common.BLL.Logic.GasStation.Traffic(Common.Enum.EDatabase.GasStation); CommandResult result1 = lTraffic.read(modelTraffic, "tagId"); if (result1.status == BaseDAL.Base.EnumCommandStatus.success) { CommandResult resultTagTraffic = lTraffic.delete(modelTraffic); if (resultTagTraffic.status == BaseDAL.Base.EnumCommandStatus.success) { // Delete Tag from table Tag Common.BLL.Entity.GasStation.Tag modelTag = new Common.BLL.Entity.GasStation.Tag() { id = tagId }; Common.BLL.Logic.GasStation.Tag lTag = new Common.BLL.Logic.GasStation.Tag(Common.Enum.EDatabase.GasStation); CommandResult result2 = lTag.read(modelTag, "tagId"); if (result2.status == BaseDAL.Base.EnumCommandStatus.success) { CommandResult resultTag = lTag.delete(modelTag); if (resultTag.status == BaseDAL.Base.EnumCommandStatus.success) { result = true; } } } } } } return(result); }
/// <summary> /// Write tag to db /// </summary> /// <param name="tagId"></param> private void writeToDB(string tagId) { Common.BLL.Logic.GasStation.Traffic lTraffic = new Common.BLL.Logic.GasStation.Traffic(Common.Enum.EDatabase.GasStation); Common.BLL.Entity.GasStation.Tag tag = new Common.BLL.Entity.GasStation.Tag() { tag = tagId }; lTraffic.insertTagByService(tag, serviceUser, DateTime.Now, interval); }
/// <summary> /// Insert tag /// </summary> /// <returns></returns> public CommandResult insertTagByService(Common.BLL.Entity.GasStation.Tag tag, Common.BLL.Entity.GasStation.User user, DateTime regDate, int intervalTime) { CommandResult result = null; if ((null != tag) && (null != user)) { // Register new traffic result = BaseDAL.DBaseHelper.executeCommand(BaseDAL.Base.EnumExecuteType.procedureNonQuery, connection, C_spTrafficRegisterByService, true, new KeyValuePair("@tagData", tag.tag), new KeyValuePair("@insertedById", user.id), new KeyValuePair("@trafficDate", regDate), new KeyValuePair("@intervalTime", intervalTime) ); } else { result = CommandResult.makeNullDataResult(); } return(result); }