Beispiel #1
0
 public IHttpActionResult UpdateOperatorDriverTruckAttachment(OperatorDriverTruckAttachment operatorDriverTruckAttachment)
 {
     try
     {
         var result = new OperatorDriverBO().UpdateOperatorDriverTruckAttachment(operatorDriverTruckAttachment);
         if (result == true)
         {
             return(Ok(new { Status = UTILITY.SUCCESSMESSAGE }));
         }
         else
         {
             return(Ok(new { Status = UTILITY.FAILEDMESSAGE }));
         }
     }
     catch (Exception ex)
     {
         return(InternalServerError(ex));
     }
 }
Beispiel #2
0
        public bool Update <T>(T item)
        {
            var result = 0;
            OperatorDriverTruckAttachment operatorDriverTruckAttachment = (OperatorDriverTruckAttachment)(object)item;

            if (currentTransaction == null)
            {
                connection = db.CreateConnection();
                connection.Open();
            }

            DbTransaction transaction = (currentTransaction == null ? connection.BeginTransaction() : currentTransaction);

            try
            {
                DbCommand savecommand = db.GetStoredProcCommand(DBRoutine.UPDATEOPERATORDRIVERVEHICLEATTACHMENTLIST);

                db.AddInParameter(savecommand, "DriverID", System.Data.DbType.String, operatorDriverTruckAttachment.DriverID);
                db.AddInParameter(savecommand, "VehicleNo", System.Data.DbType.String, operatorDriverTruckAttachment.VehicleNo);
                db.AddInParameter(savecommand, "OperatorMobNo", System.Data.DbType.String, operatorDriverTruckAttachment.OperatorMobNo);
                // db.AddInParameter(savecommand, "Status", System.Data.DbType.String, operatorDriverTruckAttachment.Status);

                result = db.ExecuteNonQuery(savecommand, transaction);

                if (currentTransaction == null)
                {
                    transaction.Commit();
                }
            }
            catch (Exception ex)
            {
                if (currentTransaction == null)
                {
                    transaction.Rollback();
                }

                throw;
            }
            return(result > 0 ? true : false);
        }
Beispiel #3
0
 public bool UpdateOperatorDriverTruckAttachment(OperatorDriverTruckAttachment operatorDriverTruckAttachment)
 {
     return(operatorDriverDAL.Update(operatorDriverTruckAttachment));
 }