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