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