Ejemplo n.º 1
0
 public bool CancelServiceRequest(int service_id)
 {
     try
     {
         CommanDB          procConn = new CommanDB();
         OracleParameter[] param    =
         {
             new OracleParameter("@p_SERVICE_ID", service_id)
         };
         procConn.RunProc("CANCELSERVICE_SP", param);
         return(true);
     }
     catch (Exception ex)
     {
         throw new UpdateException(language, ex.Message);
     }
 }
Ejemplo n.º 2
0
 public bool ChangePhoneNumber(string phoneNumber, int user_id)
 {
     try
     {
         CommanDB          procConn = new CommanDB();
         OracleParameter[] param    =
         {
             new OracleParameter("@p_phoneNumber", phoneNumber),
             new OracleParameter("@p_user_Id",     user_id)
         };
         procConn.RunProc("changePhoneNumber_sp", param);
         return(true);
     }
     catch (Exception ex)
     {
         throw new UpdateException(language, ex.Message);
     }
 }
Ejemplo n.º 3
0
 public bool InsertService(serviceRequest serviceRequest, int user_id)
 {
     try
     {
         CommanDB          procConn = new CommanDB();
         OracleParameter[] param    =
         {
             new OracleParameter("@p_SERVICE_ID", serviceRequest.SERVICE_ID),
             new OracleParameter("@p_SRCX",       serviceRequest.SRCX),
             new OracleParameter("@p_SRCY",       serviceRequest.SRCY),
             new OracleParameter("@p_DESTX",      serviceRequest.DESTX),
             new OracleParameter("@p_DESTX",      serviceRequest.DESTY),
             new OracleParameter("@p_USER_ID",    user_id)
         };
         procConn.RunProc("insertService_sp", param);
         return(true);
     }
     catch (Exception ex)
     {
         throw new InsertException(language, ex.Message);
     }
 }
Ejemplo n.º 4
0
 public bool InsertBill(BillFix bill)
 {
     try
     {
         CommanDB          procConn = new CommanDB();
         OracleParameter[] param    =
         {
             new OracleParameter("@p_accident_id", bill.accident_id),
             new OracleParameter("@p_workshop_id", bill.workshop_id),
             new OracleParameter("@p_fix_price",   bill.fix_price),
             new OracleParameter("@p_spare_price", bill.spare_price),
             new OracleParameter("@p_trans_price", bill.TRANSCAR_PRICE),
             new OracleParameter("@p_rent_price",  bill.rent_price),
             new OracleParameter("@p_note",        bill.note),
         };
         procConn.RunProc("insertBill_sp", param);
         return(true);
     }
     catch (Exception ex)
     {
         throw new InsertException(language, ex.Message);
     }
 }