コード例 #1
0
 public bool SaveOutward(OutwardModel model)
 {
     try
     {
         if (model != null)
         {
             OutwardMaster outward = new OutwardMaster
             {
                 challandate         = model.challandate,
                 vehicleNo           = model.vehicleNo,
                 vehiclecapacityMT   = model.vehiclecapacityMT,
                 challantype         = model.challantype,
                 challanNo           = model.challanNo,
                 frombranch          = model.frombranch,
                 tobranch            = model.tobranch,
                 brokerloadingslipno = model.brokerloadingslipno,
                 brokername          = model.brokername,
                 drivername          = model.drivername,
                 driverlicenceNo     = model.driverlicenceNo,
                 drivermobileNo      = model.drivermobileNo,
                 CNno              = model.CNno,
                 CNdate            = model.CNdate,
                 bookingbranch     = model.bookingbranch,
                 deliverylocation  = model.deliverylocation,
                 deliverytype      = model.deliverytype,
                 balancepackeges   = model.balancepackeges,
                 balanceweight     = model.balanceweight,
                 loadedpackages    = model.loadedpackages,
                 loadedweight      = model.loadedweight,
                 rollno            = model.rollno,
                 truckhirechareges = model.truckhirechareges,
                 othercharges      = model.othercharges,
                 TDS              = model.TDS,
                 TDSamount        = model.TDSamount,
                 totaltruckhire   = model.totaltruckhire,
                 advence          = model.advence,
                 advencepayableAt = model.advencepayableAt,
                 balancepayableAt = model.balancepayableAt,
                 RC  = model.RC,
                 PAN = model.PAN,
                 drivinglicenceAttach = model.drivinglicenceAttach,
                 loadinglicenceAttach = model.loadinglicenceAttach,
                 TransitDays          = model.TransitDays,
                 isActive             = true,
             };
             tRSEntities4.OutwardMasters.Add(outward);
             tRSEntities4.SaveChanges();
             return(true);
         }
         else
         {
             return(false);
         }
     }
     catch (Exception e)
     {
         throw e;
     }
 }
コード例 #2
0
 public List <OutwardModel> GetOutwardModels()
 {
     try
     {
         var data = tRSEntities4.OutwardMasters.Where(x => x.isActive == true).ToList();
         List <OutwardModel> outwards = new List <OutwardModel>();
         foreach (var item in data)
         {
             OutwardModel model = new OutwardModel
             {
                 id                   = item.id,
                 challandate          = item.challandate,
                 vehicleNo            = item.vehicleNo,
                 vehiclecapacityMT    = item.vehiclecapacityMT,
                 challanNo            = item.challanNo,
                 frombranch           = item.frombranch,
                 tobranch             = item.tobranch,
                 brokerloadingslipno  = item.brokerloadingslipno,
                 brokername           = item.brokername,
                 drivername           = item.drivername,
                 driverlicenceNo      = item.driverlicenceNo,
                 drivermobileNo       = item.drivermobileNo,
                 CNno                 = item.CNno,
                 CNdate               = item.CNdate,
                 bookingbranch        = item.bookingbranch,
                 deliverylocation     = item.deliverylocation,
                 deliverytype         = item.deliverytype,
                 balancepackeges      = item.balancepackeges,
                 balanceweight        = item.balanceweight,
                 loadedpackages       = item.loadedpackages,
                 rollno               = item.rollno,
                 truckhirechareges    = item.truckhirechareges,
                 othercharges         = item.othercharges,
                 TDS                  = item.TDS,
                 TDSamount            = item.TDSamount,
                 totaltruckhire       = item.totaltruckhire,
                 advence              = item.advence,
                 advencepayableAt     = item.advencepayableAt,
                 balancepayableAt     = item.balancepayableAt,
                 RC                   = item.RC,
                 PAN                  = item.PAN,
                 drivinglicenceAttach = item.drivinglicenceAttach,
                 loadinglicenceAttach = item.loadinglicenceAttach,
                 TransitDays          = item.TransitDays,
                 isActive             = (bool)item.isActive,
                 frombranchname       = tRSEntities4.BranchMasters.Where(x => x.id == item.frombranch).Select(x => x.branchName).FirstOrDefault(),
                 vehicleName          = tRSEntities4.VehicleMasters.Where(x => x.id == item.vehicleNo).Select(x => x.vehicleNo).FirstOrDefault(),
             };
             outwards.Add(model);
         }
         return(outwards);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
コード例 #3
0
 public OutwardModel GetOutwardModel(int id)
 {
     try
     {
         var data = tRSEntities4.OutwardMasters.Where(x => x.id == id && x.isActive == true).FirstOrDefault();
         if (data != null)
         {
             OutwardModel model = new OutwardModel();
             model.id                   = data.id;
             model.challandate          = data.challandate;
             model.vehicleNo            = data.vehicleNo;
             model.vehiclecapacityMT    = data.vehiclecapacityMT;
             model.challantype          = data.challantype;
             model.challanNo            = data.challanNo;
             model.frombranch           = data.frombranch;
             model.tobranch             = data.tobranch;
             model.brokerloadingslipno  = data.brokerloadingslipno;
             model.brokername           = data.brokername;
             model.drivername           = data.drivername;
             model.driverlicenceNo      = data.driverlicenceNo;
             model.drivermobileNo       = data.drivermobileNo;
             model.CNno                 = data.CNno;
             model.CNdate               = data.CNdate;
             model.bookingbranch        = data.bookingbranch;
             model.deliverylocation     = data.deliverylocation;
             model.deliverytype         = data.deliverytype;
             model.balancepackeges      = data.balancepackeges;
             model.balanceweight        = data.balanceweight;
             model.loadedpackages       = data.loadedpackages;
             model.loadedweight         = data.loadedweight;
             model.rollno               = data.rollno;
             model.truckhirechareges    = data.truckhirechareges;
             model.othercharges         = data.othercharges;
             model.TDS                  = data.TDS;
             model.TDSamount            = data.TDSamount;
             model.totaltruckhire       = data.totaltruckhire;
             model.advence              = data.advence;
             model.advencepayableAt     = data.advencepayableAt;
             model.balancepayableAt     = data.balancepayableAt;
             model.RC                   = data.RC;
             model.PAN                  = data.PAN;
             model.drivinglicenceAttach = data.drivinglicenceAttach;
             model.loadinglicenceAttach = data.loadinglicenceAttach;
             model.TransitDays          = data.TransitDays;
             model.isActive             = (bool)data.isActive;
             return(model);
         }
         else
         {
             return(null);
         }
     }
     catch (Exception e)
     {
         throw e;
     }
 }
コード例 #4
0
 public bool UpdateOutward(OutwardModel model)
 {
     try
     {
         var data = tRSEntities4.OutwardMasters.Where(x => x.id == model.id && x.isActive == true).FirstOrDefault();
         if (data != null)
         {
             data.challandate         = model.challandate;
             data.vehicleNo           = model.vehicleNo;
             data.vehiclecapacityMT   = model.vehiclecapacityMT;
             data.challantype         = model.challantype;
             data.challanNo           = model.challanNo;
             data.frombranch          = model.frombranch;
             data.tobranch            = model.tobranch;
             data.brokerloadingslipno = model.brokerloadingslipno;
             data.brokername          = model.brokername;
             data.drivername          = model.drivername;
             data.driverlicenceNo     = model.driverlicenceNo;
             data.drivermobileNo      = model.drivermobileNo;
             data.CNno              = model.CNno;
             data.CNdate            = model.CNdate;
             data.bookingbranch     = model.bookingbranch;
             data.deliverylocation  = model.deliverylocation;
             data.deliverytype      = model.deliverytype;
             data.balancepackeges   = model.balancepackeges;
             data.balanceweight     = model.balanceweight;
             data.loadedpackages    = model.loadedpackages;
             data.loadedweight      = model.loadedweight;
             data.rollno            = model.rollno;
             data.truckhirechareges = model.truckhirechareges;
             data.othercharges      = model.othercharges;
             data.TDS              = model.TDS;
             data.TDSamount        = model.TDSamount;
             data.totaltruckhire   = model.totaltruckhire;
             data.advence          = model.advence;
             data.advencepayableAt = model.advencepayableAt;
             data.balancepayableAt = model.balancepayableAt;
             data.RC  = model.RC;
             data.PAN = model.PAN;
             data.drivinglicenceAttach = model.drivinglicenceAttach;
             data.loadinglicenceAttach = model.loadinglicenceAttach;
             data.TransitDays          = model.TransitDays;
             data.isActive             = true;
             tRSEntities4.SaveChanges();
             return(true);
         }
         else
         {
             return(false);
         }
     }
     catch (Exception e)
     {
         throw e;
     }
 }
コード例 #5
0
        public IHttpActionResult UpdateOutward(OutwardModel model)
        {
            var data = outwardRepo.UpdateOutward(model);

            return(Ok(data));
        }