internal Model_ManualWeight gettransactionDetail(string truckNo) { Model_ManualWeight model = new Model_ManualWeight(); tblTransaction trans = db.tblTransactions.Where(x => x.TruckNo == truckNo && x.TransactionStatus == 1).FirstOrDefault(); if (trans != null) { model.trans = trans; //IEnumerable<tblTransactionWeight> weightList = db.tblTransactionWeights.Where(x => x.TransactionId == trans.Id); //model.transWeight = weightList; } return(model); }
public string GetTransactionDetail(string truckNo) { Model_ManualWeight model = new Model_ManualWeight(); if (_transactionRepo.checkTruckIsPendingOrNot(truckNo)) { model = _transactionRepo.gettransactionDetail(truckNo); if (model != null) { //if (model.transWeight != null) //{ // List<Mode_transactionWeight> _weight = _transactionRepo.GetTruckWeight(truckNo); //} } } model.truckMaster = _truckRepo.GetTruckMasterByTruckNo(truckNo); model.VC = _VCRepo.GetTruckVehicleClassification(truckNo); model.transmaterials = _transactionRepo.gettransactionmaterials(truckNo).Skip(1); string myJsonString = (new JavaScriptSerializer()).Serialize(model); return(myJsonString); }
//public List<Mode_transactionWeight> GetTruckWeight(string truckNo) //{ // var res = (from a in db.tblTransactions // join b in db.tblTransactionWeights on a.Id equals b.TransactionId // where a.TruckNo == truckNo && a.TransactionStatus == 1 // select new Mode_transactionWeight // { // TransactionId = (int)b.TransactionId, // Id = b.Id, // Weight = (decimal)b.Weight, // WeightDate = (DateTime)b.WeightDate, // WeightTime = (DateTime)b.WeightTime, // }).ToList(); // return res; //} internal void saveTransactionRecord(Model_ManualWeight model) { tblTransaction trans = db.tblTransactions.FirstOrDefault(x => x.TruckNo == model.trans.TruckNo && x.TransactionStatus == 1); if (trans == null) { trans = new tblTransaction(); trans = model.trans; trans.WeighbridgeId = model.WeibridgeId; trans.CreatedBy = model.UserName; trans.Shift = model.shiftName; trans.PlantCode = model.plantCode; trans.CompanyCode = model.companyCode; db.tblTransactions.InsertOnSubmit(trans); db.SubmitChanges(); int transId = trans.Id; //tblTransactionWeight wei = model.Weight; //wei.TransactionId = transId; //db.tblTransactionWeights.InsertOnSubmit(wei); //db.SubmitChanges(); } else { trans.TripType = model.trans.TripType; trans.SecondWeight = model.trans.SecondWeight; trans.SecondWtDateTime = model.trans.SecondWtDateTime; trans.NetWeight = model.trans.NetWeight; trans.TripType = model.trans.TripType; trans.Shift = model.trans.Shift; trans.SHIFTDATE = model.trans.SHIFTDATE; trans.FrontImage2 = model.trans.FrontImage2; trans.BackImage2 = model.trans.BackImage2; trans.PlantCode = model.trans.PlantCode; trans.CompanyCode = model.trans.CompanyCode; trans.WeighbridgeId = model.trans.WeighbridgeId; trans.SupplierCode = model.trans.SupplierCode; trans.SupplierName = model.trans.SupplierName; trans.TransporterCode = model.trans.TransporterCode; trans.TransporterName = model.trans.TransporterName; trans.MaterialCode = model.trans.MaterialCode; trans.MaterialName = model.trans.MaterialName; if (trans.IsMultiProduct == false) { trans.TransactionStatus = 2; db.SubmitChanges(); } int transId = trans.Id; if (model.material != null) { db.tblTransactionMaterials.InsertOnSubmit(model.material); db.SubmitChanges(); } TruckTareWeight _tarewt = db.TruckTareWeights.FirstOrDefault(); _tarewt = new TruckTareWeight(); if (trans.TripType == 1) { _tarewt.TruckNo = trans.TruckNo; _tarewt.TareWeight = trans.SecondWeight; _tarewt.TareWtDateTime = trans.SecondWtDateTime; } else { _tarewt.TruckNo = trans.TruckNo; _tarewt.TareWeight = trans.FirstWeight; _tarewt.TareWtDateTime = trans.FirstWtDateTime; } db.TruckTareWeights.InsertOnSubmit(_tarewt); db.SubmitChanges(); } }